Viewing 15 posts - 42,031 through 42,045 (of 49,562 total)
ervin_brosas (1/1/2009)
I need to migrate the database from SQL 2005 to SQL Server 2000.
The only way to do that is to script all of the objects out, bcp all the...
January 2, 2009 at 4:02 am
talk2riya15 (1/1/2009)
i want to add more column dynamically by using store procedure......how can i do this????
Why do you need to do this?
January 2, 2009 at 2:14 am
Mad-Dog (1/2/2009)
January 2, 2009 at 2:05 am
David O (1/1/2009)
Pretty sure now it is the version of Sql and the OS I'm trying to use instead of 32 bit on x64 bit OS.
What edition of SQL...
January 2, 2009 at 12:18 am
GilaMonster (1/1/2009)
Please post table structure (as create table statements), some sample data and your expected results. Read this to see the best way to post this to get quick responses.http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 2, 2009 at 12:15 am
David O (12/31/2008)
I just rebuilt my work station Win x64 ... and the RTM disk tells me my OS isn't supported.
What OS are you using? What edition of SQL...
January 1, 2009 at 2:19 pm
Jeff Moden (1/1/2009)
This is obviously either homework or an interview test.
And it doesn't appear to be particularly urgent.
January 1, 2009 at 2:13 pm
As I asked before, have you read through the sections in Books Online on the encryption hierarchy and how the encryption works?
A very quick google search on EncryptByPassphrase turned these...
January 1, 2009 at 1:50 pm
ALZDBA (1/1/2009)
first read: http://www.sommarskog.se/dynamic_sql.htmlThen : this is certainly not a best practice !
In addition, make sure you know what SQL injection is and how to prevent it.
January 1, 2009 at 1:45 pm
Just make sure that you have the correct data types in your source table, ie dates are stored as datetimes and the numbers are stored as numeric, decimal or money,...
January 1, 2009 at 12:14 pm
WayneS (1/1/2009)
Just prior to the full backup, we run a "backup log with no_log", followed by a "dbcc shrinkfile" on the database log file to shrink it to 50mb.
Why? If...
January 1, 2009 at 11:32 am
Mark (1/1/2009)
The problem I have with his solution is that he has a predefined set. No one has a predefined set of data in the real world.
That's...
January 1, 2009 at 11:31 am
I'll check the exec plan when I get SQL reinstalled. In the meantime, what's the definition of fnGetTerrTree, and can you post the schemas of the tables (as create table...
January 1, 2009 at 11:24 am
Please post table structure (as create table statements), some sample data and your expected results. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Do you...
January 1, 2009 at 5:57 am
What are the queries associated?
DBID 32757 is the resource database, where all the system views, functions and procedures are stored. So if the queries that you see are system procs,...
January 1, 2009 at 5:38 am
Viewing 15 posts - 42,031 through 42,045 (of 49,562 total)