I was suggested the following link in another forum and it fixed my problem. http://support.microsoft.com/default.aspx?scid=kb;en-us;306457
Hi Frank, Thank you for the suggestion. But, I don't think that the worker threads that these jobs are waiting on are CPU related threads. Because,...
I have more than 100 SQL Server jobs scheduled to run simultaneously and continuosly. Several of these jobs are not running and with the status...
It looks like the drive that contains the transaction log file for this database, is full. Check the free space available on this drive. If it is...
There is a 'MAXDOP' option you can use in SELECT statement to limit the degree of paralleism. There is also an sp_configure option to set 'Cost...
1. dbcc traceoff with the same trace numbers will turn off the trace 2. You have to run it on the SQL server 3. You will find in the result, what...
It is only available in Enterprise Edition of SQL Server. If you have standard edition, then you have to use custom built log shipping solutions....
Is this job created locally or from another server as a remote job ? If it has been created remotely, then you have to delete it from that server.<br...
column level collation is also same on both of these tables. I want to confirm that the order depends on the execution plan. If there is no order by...
Hi all, I have 2 identical databases in a server. The following query on these databases giving the output in different sort order : select...
Looks like I need Microsoft Office Live Meeting software to view these webcasts. Is it available for download anywhere ? Can any one provide a link ?
I've found a registry key where this information is stored. It is HKLMSoftwareMicrosoftMicrosoft SQL Server80ToolsSQLEWRegistered Servers X. But,...
If you are using SQL server standard version, it can not use more than 2 GB.
Space available shows the total empty space available in your database (both data and log) files. I believe this uses the same system tables that...
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us
I've finally figured it out. Thought this would be helpful to someone. I had to setup the following in the Connection string of the data source:...
If the backup is taking more than 5 hours, then I assume it's a huge database. For such huge databases, it's better to take a locak backup and copy...
Try executing sp_revokedbaccess, qualified with the database name that you want to run it on. Ex: Exec dbname..sp_revokedbaccess
Also, I recommend you all to ocassionally visit this SQL Server 2005 forum, to know what's going on with the much awaited latest version....
The simplest way is, create a column with datetime data type and assign a default of getdate() to it. For example: Alter table xyz add tmstmp...
Separate names with a comma.
