Extract Database from Master

I've a database (Citrix Data Store) that's stored in the master database (but shouldn't be). I need to extract the "Data Store" from the master
Citrix have some documentation on this:
http://support.citrix.com/article/CTX104452&searchID=10596990
The article states:
"Remove all the master database references from the new database (Please consult SQL documentation)"
My question: how do I do the above? Pointers welcome.
- Seán
Belatedly moving this thread to the database engine forum...

Extract Database from Master

I've a database (Citrix Data Store) that's stored in the master database (but shouldn't be). I need to extract the "Data Store" from the master
Citrix have some documentation on this:
http://support.citrix.com/article/CTX104452&searchID=10596990
The article states:
"Remove all the master database references from the new database (Please consult SQL documentation)"
My question: how do I do the above? Pointers welcome.
- Seán
Belatedly moving this thread to the database engine forum...

External logs collection and monitoring

Essentially I am looking for a way to externally store db
audit logs and to be able to parse the data or filter for specific events an
d
ids for review by a security team. Something less manual than copying trace
files from the server to another server and going over each using profiler
(we're talking about 30 servers here!)... but not necessarily as hands-off a
s
flagging and email alerting only.
In going through support docs and threads here a couple questions have also
arisen...
Does the table the trace dumps to have to be part of the local db? Is it
possible to have the trace dump to an external db server?
In order to have trace dump the output to a table, does this require setting
up a job using SQL Trace stored procedures or can it be done just by changin
g
the server's auditing configuration?Server side traces (i.e. without using the Profiler GUI) can only write to
trace files. You can load trace files into a sql table (for example on a
central "audit" server) using the sytem function fn_trace_gettable. See BOL
for details
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JMBickham" <JMBickham@.discussions.microsoft.com> wrote in message
news:AF4060D6-6986-4999-85E3-5B090EC39A53@.microsoft.com...
> Essentially I am looking for a way to externally store db
> audit logs and to be able to parse the data or filter for specific events
> and
> ids for review by a security team. Something less manual than copying
> trace
> files from the server to another server and going over each using profiler
> (we're talking about 30 servers here!)... but not necessarily as hands-off
> as
> flagging and email alerting only.
> In going through support docs and threads here a couple questions have
> also
> arisen...
> Does the table the trace dumps to have to be part of the local db? Is it
> possible to have the trace dump to an external db server?
> In order to have trace dump the output to a table, does this require
> setting
> up a job using SQL Trace stored procedures or can it be done just by
> changing
> the server's auditing configuration?sql

Extended Store Procedure Query

Please help me..
I am stuck on the Problem related to Store Procedure
I want to use Extended Store Procedure.
I read tech document related that on MSDN,
but i am unable to register the Extended Store Procedure.
Please guide me step wise step, So that I can register the extended
store Procedure (.DLL)
File in SQL Server.
I also want to Kow How to use it in our Program.
With regards
Tarun SinhaCopy the DLL into a suitable directory on the machine running
SQL Server, typically
C:\Program Files\Microsoft SQL Server\MSSQL\binn
Register the extended stored procedure using
exec sp_addextendedproc N'myxp', N'myxp.dll'
You can execute it using
exec master.dbo.myxp
remembering to supply any parameters it requires.|||To install the DLL,
copy the file to the directory containing the standard SQL Server DLL
files (C:\Program Files\Microsoft SQL Server\Mssql\Binn by default).
then run this (of course your name will be different)
sp_addextendedproc 'xp_YourProc', 'xp_YourProc.dll'
http://sqlservercode.blogspot.com/|||Hello
Thank's for replying me
I would I Know What Parameter the Extended Store Procedure Take .
Please consider this Stupid Question and reply me.
I download xpRegex.dll and copy it in C:\Program Files\Microsoft SQL
Server\MSSQL\binn ,
I Also Register in the extended store Procedure, but How to Know what
parameter it takes.
With regards
Tarun sinha|||In order to find out the parameters it needs for execution, you
will need to refer back to the documentation from where you
downloaded it. You can't tell otherwise.
Registering it doesn't require any parameters, although it is possible
to have multiple entry points in the same DLL. In which case
you would call sp_addextendedproc once per entry point, e.g.
exec sp_addextendedproc N'xpRegex_X', N'xpRegex.dll'
exec sp_addextendedproc N'xpRegex_Y', N'xpRegex.dll'
All this should be explained in the place where you downloaded it.|||Thank You sir
U explain my query so well ..
I am great thank ful to you
with regards
Tarun Sinha

Extended Property

Hello All
I am Not aware about the Extended Property. Can Anyone
explain me what is Extended Property... where it use ... how it use..
I have an store procedure along with parameter is calling, But I am not
able to understand the
this store procedure.
exec sp_addextendedproperty 'FKLookupDisplay', 'Description', 'user',
dbo, 'table', 'Amortization'
What the above store procedure does 'hi,
tarun.sinha@.gmail.com wrote:
> Hello All
> I am Not aware about the Extended Property. Can Anyone
> explain me what is Extended Property... where it use ... how it
> use..
> I have an store procedure along with parameter is calling, But I am
> not able to understand the
> this store procedure.
> exec sp_addextendedproperty 'FKLookupDisplay', 'Description', 'user',
> dbo, 'table', 'Amortization'
> What the above store procedure does '
have a look at http://www.devx.com/dbzone/Article/27793/0
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply|||I have understood the the Extended Property but it not crystal clear ,
Can any one explain a bit with example '
Andrea Montanari wrote:
> hi,
> tarun.sinha@.gmail.com wrote:
> have a look at http://www.devx.com/dbzone/Article/27793/0
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
> -- remove DMO to reply|||hi,
tarun.sinha@.gmail.com wrote:
> I have understood the the Extended Property but it not crystal clear ,
> Can any one explain a bit with example '
SET NOCOUNT ON;
USE tempdb;
GO
CREATE TABLE dbo.testTable (
Id int NOT NULL
);
GO
PRINT 'adding 2 extended properties to the table object';
EXEC sp_addextendedproperty 'prop_name' , 'property value' , 'user' , 'dbo'
, 'table' , 'testTable' , NULL , NULL;
EXEC sp_addextendedproperty 'prop_name2' , 'property value' , 'user' , 'dbo'
, 'table' , 'testTable' , NULL , NULL;
PRINT 'modifying an extended property value';
EXEC sp_updateextendedproperty 'prop_name' , 'new property value' , 'user' ,
'dbo' , 'table' , 'testTable' , NULL , NULL;
PRINT 'lists all extended properties available on dbo.testTable';
SELECT * FROM ::fn_listextendedproperty( NULL , 'user' , 'dbo' , 'table' ,
'testTable' , NULL , NULL );
PRINT 'drop an extended property';
EXEC sp_dropextendedproperty 'prop_name', 'user' ,'dbo' , 'table' ,
'testTable';
GO
DROP TABLE dbo.testTable;
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply

Expressions as a field value in a table

Is there a way to store an expression inside a table, and have the expression
being pulled from the table to execute during run time? I want to dynamically
create an expression based on the value of a column of the table. Using the
IIF statement will work but it's going to be a very long nested IIF.... and
that brings to the second question -> is there a limit for the length of an
expression?
Thanks in advance.There is no limit on the length of an expression (other than limits imposed
by the VB.NET compiler).
In your case, you may want to look at alternatives to the IIF function:
* =Choose(...)
http://msdn.microsoft.com/library/en-us/vblr7/html/vafctchoose.asp
* =Switch(...)
http://msdn.microsoft.com/library/en-us/vblr7/html/vafctswitch.asp
In addition, you may want to consider writing a function in custom code or
as custom assembly that contains your logic. You can then reuse the function
from RDL expressions.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"g3kamdbs" <g3kamdbs@.discussions.microsoft.com> wrote in message
news:2A1DC075-220C-4494-AF82-157760B3EBD5@.microsoft.com...
> Is there a way to store an expression inside a table, and have the
> expression
> being pulled from the table to execute during run time? I want to
> dynamically
> create an expression based on the value of a column of the table. Using
> the
> IIF statement will work but it's going to be a very long nested IIF....
> and
> that brings to the second question -> is there a limit for the length of
> an
> expression?
> Thanks in advance.|||Or a User Defined Function that the Stored Procedure calls.
GeoSynch
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:uO3ZYBwvFHA.252@.TK2MSFTNGP09.phx.gbl...
> There is no limit on the length of an expression (other than limits imposed by
> the VB.NET compiler).
> In your case, you may want to look at alternatives to the IIF function:
> * =Choose(...)
> http://msdn.microsoft.com/library/en-us/vblr7/html/vafctchoose.asp
> * =Switch(...)
> http://msdn.microsoft.com/library/en-us/vblr7/html/vafctswitch.asp
> In addition, you may want to consider writing a function in custom code or as
> custom assembly that contains your logic. You can then reuse the function from
> RDL expressions.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "g3kamdbs" <g3kamdbs@.discussions.microsoft.com> wrote in message
> news:2A1DC075-220C-4494-AF82-157760B3EBD5@.microsoft.com...
>> Is there a way to store an expression inside a table, and have the expression
>> being pulled from the table to execute during run time? I want to dynamically
>> create an expression based on the value of a column of the table. Using the
>> IIF statement will work but it's going to be a very long nested IIF.... and
>> that brings to the second question -> is there a limit for the length of an
>> expression?
>> Thanks in advance.
>

Exporting XML to a file

Is there a way to get BCP or a sql store procedure to export my database to
a
XML file ?You may use FOR XML queries to export you all db as XML.
"rseedle" <rseedle@.discussions.microsoft.com> wrote in message
news:35182A41-7226-4D91-84B7-576301CBB400@.microsoft.com...
> Is there a way to get BCP or a sql store procedure to export my database
> to a
> XML file ?|||I guess what I really want to know is, how do I get the results of the selec
t
... for XML to a file. Getting it to display on the screen is nice but I
really needs it to be in a file.
Randy
"Bertan ARI [MSFT]" wrote:

> You may use FOR XML queries to export you all db as XML.
>
> "rseedle" <rseedle@.discussions.microsoft.com> wrote in message
> news:35182A41-7226-4D91-84B7-576301CBB400@.microsoft.com...
>
>|||In addition, when I run the query:
select * from Users for xml auto
or
select * from Users for xml raw
Query analyzer truncates the text that gets displayed. So if I do tell it to
save it to a file in Query Analyzer the XML data is truncated.
"rseedle" wrote:
> I guess what I really want to know is, how do I get the results of the sel
ect
> ... for XML to a file. Getting it to display on the screen is nice but I
> really needs it to be in a file.
> Randy
> "Bertan ARI [MSFT]" wrote:
>|||You have to write a small APP that will execute your query and store the
results in a file stream.
"rseedle" <rseedle@.discussions.microsoft.com> wrote in message
news:8A27F4A1-0D39-47E0-A4CE-E77EC2ECED58@.microsoft.com...
> In addition, when I run the query:
> select * from Users for xml auto
> or
> select * from Users for xml raw
> Query analyzer truncates the text that gets displayed. So if I do tell it
> to
> save it to a file in Query Analyzer the XML data is truncated.
>
> "rseedle" wrote:
>

Exporting XML to a file

Is there a way to get BCP or a sql store procedure to export my database to a
XML file ?
You may use FOR XML queries to export you all db as XML.
"rseedle" <rseedle@.discussions.microsoft.com> wrote in message
news:35182A41-7226-4D91-84B7-576301CBB400@.microsoft.com...
> Is there a way to get BCP or a sql store procedure to export my database
> to a
> XML file ?
|||I guess what I really want to know is, how do I get the results of the select
... for XML to a file. Getting it to display on the screen is nice but I
really needs it to be in a file.
Randy
"Bertan ARI [MSFT]" wrote:

> You may use FOR XML queries to export you all db as XML.
>
> "rseedle" <rseedle@.discussions.microsoft.com> wrote in message
> news:35182A41-7226-4D91-84B7-576301CBB400@.microsoft.com...
>
>
|||In addition, when I run the query:
select * from Users for xml auto
or
select * from Users for xml raw
Query analyzer truncates the text that gets displayed. So if I do tell it to
save it to a file in Query Analyzer the XML data is truncated.
"rseedle" wrote:
[vbcol=seagreen]
> I guess what I really want to know is, how do I get the results of the select
> ... for XML to a file. Getting it to display on the screen is nice but I
> really needs it to be in a file.
> Randy
> "Bertan ARI [MSFT]" wrote:
|||You have to write a small APP that will execute your query and store the
results in a file stream.
"rseedle" <rseedle@.discussions.microsoft.com> wrote in message
news:8A27F4A1-0D39-47E0-A4CE-E77EC2ECED58@.microsoft.com...[vbcol=seagreen]
> In addition, when I run the query:
> select * from Users for xml auto
> or
> select * from Users for xml raw
> Query analyzer truncates the text that gets displayed. So if I do tell it
> to
> save it to a file in Query Analyzer the XML data is truncated.
>
> "rseedle" wrote:

exporting store procedure and indexes

I use sql server 2005 and i want to export to another server but when i export the store procedure and indexes and keys does not export

How did you export the database, which settings did you use ?

Jens Suessmeyer.

http://www.sqlserver2005.de