Viewing 15 posts - 61 through 75 (of 98 total)
Oracle_91 (4/26/2011)
What is the difference between creating an Alias using SQL Configuration manager and creating an Alias using SQL Server client Network utility?
Does both come along with SQL Server 2005...
April 26, 2011 at 5:06 am
can you try to be more precise about your problem. Sothat we could help you in that direction..
April 26, 2011 at 5:00 am
It seems that you want a script which could read through the text files and dump the data into tables into sql server.
If , my understanding is correct , then...
April 1, 2011 at 2:26 am
you can also use SORT_IN_TEMPDB =ON option.
It might make your index rebuilding operation faster if the data files of your tempdb database
is on a different set of disks. But...
January 19, 2011 at 10:14 pm
sorry i guess i am late to reply the above solution...
January 17, 2011 at 12:59 am
Jpotucek (1/14/2011)
C:\Users\isjxr18>sqlcmd -s kocsql05\sharepoint
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server...
January 17, 2011 at 12:55 am
the.hank (1/14/2011)
January 17, 2011 at 12:39 am
Deepak Sahu (1/14/2011)
Could anyone throw somelight on , SQL Server Management Studio 2005 Express can connect to SQL Server 2008 Express databases?
The straight forward answer is no unless you upgrade...
January 17, 2011 at 12:16 am
Deepak Sahu (1/14/2011)
Could anyone throw somelight on , SQL Server Management Studio 2005 Express can connect to SQL Server 2008 Express databases?
The straight forward answer is no unless you upgrade...
January 17, 2011 at 12:14 am
naresh.talla (1/13/2011)
after ur rebuild index/reorganize, you scheduled shrink database log then after take a full database backup
I have a few question here..
1. will shrinking always shrink your log file...
January 13, 2011 at 12:25 am
I have had a similar situation where my database was growing to nearly 1 TB and we were having some performance issues because a few of my tables were nearly...
January 13, 2011 at 12:10 am
sqldba_icon (1/12/2011) I am runnning sql 2005 64 bit std edition with Sp3 + CU10 ..do i still need to enable the trace flag?
To Avail the benefits of Lock Pages...
January 12, 2011 at 9:34 pm
Ideally it should get a seperate Windows domain Account created with limited previleges and then you should grant the lock pages in memory right to that user.
This will...
January 12, 2011 at 9:27 pm
I will have a few questions from you which will help me to understand your problem a little bit more clearly.
pls. metion the following information.
1. is your prinicipal, Mirror and...
January 12, 2011 at 9:12 pm
SKYBVI (1/12/2011)
can you check if the auto_close_on ( db options) is enabled?
It has nothing to do with auto_close database option.
david.alcock (1/12/2011)
January 12, 2011 at 8:13 pm
Viewing 15 posts - 61 through 75 (of 98 total)