Viewing 15 posts - 136 through 150 (of 462 total)
Try killing the spid repeatedly. If that doesn't help, you might have to re-cycle the services.
February 3, 2005 at 9:59 am
can you try to connect to the server using query analyzer ?
Also, can you try to create a client alias and try registering/connect to query analyzer ?
February 3, 2005 at 9:58 am
You have many options to move databases.
1) Backup the database and restore it on the second server
2) Detach files using sp_detach_db database and copy the files to the destination server...
February 1, 2005 at 3:21 pm
When you configure a cluster, it is referred to by its virtual name and not the physical name. Say you have two servers s1 and s2. and you have two...
February 1, 2005 at 2:51 pm
Where do you have the model database ? The tempdb gets created from the model database. I recently ran into this error when i was trying to move the model...
January 28, 2005 at 2:21 pm
setup.iss is only used during installation. After installation, you can also safely delete this file without issues. Hence, no changes which you make after installation will be reflected in your...
January 28, 2005 at 2:15 pm
Do you use CDOSYS or CDONTS ? I don't think CDONTS is supported with Windows 2003.
January 28, 2005 at 2:10 pm
When you renamed your server, did you rename SQL Server. i.e you need to run sp_dropserver 'Server_name' and than run sp_addserver 'new_servername'
January 28, 2005 at 1:47 pm
Try to backup the log file and then shrink it. Perform this excercise a couple of times and all the space should be released.
January 28, 2005 at 1:44 pm
Do you already have one instance on the cluster and you want to create an additional named instance ? Or this is a new install ?
January 28, 2005 at 10:13 am
I also can't just change the user in the SQL Server Agent for that job. Here I get the error 14274 cant edit a job that comes from an MSX...
January 28, 2005 at 10:08 am
No, you cannot do that. SQL Server will write to transaction log in a sequential manner. It will start writing to the first log and after it gets filled up...
January 28, 2005 at 9:58 am
What is the growth increment set ? Also, can you just try to increase the size of the data file to 5 GB and try importing data ?
January 27, 2005 at 2:19 pm
I think there is a bug when you assign db_ddladmin permissions to an NT group and try to create objects from enterprise manager. Only some of our developers ran into this and...
January 22, 2005 at 1:00 pm
Viewing 15 posts - 136 through 150 (of 462 total)