Viewing 15 posts - 436 through 450 (of 1,161 total)
Does executing the below query generate any errors?
xp_cmdshell 'dir c:\xxx\yy\zzz\filename.xls'
November 9, 2010 at 4:15 am
There are two options.
1) To add a new data file to tempdb on a drive which has enough space.
2) Kill the SPID which is currently active on it.
Since this...
November 9, 2010 at 3:27 am
Does the folder "c:\xxx\yy\zzz" exist on the server where SQL Server is running?
November 9, 2010 at 3:24 am
This behavior is by design. To overcome this issue, you can select "All Databases" or "User databases" while creating the maintenance plan.
November 9, 2010 at 3:21 am
Assuming that you are referring to the connection strings in .Net or some other application, yes you can build the connecting string yourself. Define text parameters, assign value to them...
November 9, 2010 at 3:20 am
Check if any open transactions are there on tempdb. Once those transactions are complete the size will return to normalcy.
November 9, 2010 at 3:18 am
These screenshots should help you to read the SQL Server Error Log.
November 9, 2010 at 2:42 am
This article has the syntax for sp_purge_jobhistory. You may create a job which executes a query similar to the one below. This query deletes records older than 10 days.
DECLARE @oldestdate...
November 8, 2010 at 9:40 pm
As the error message states that particular index is disabled. Rebuild it manually to enable it or drop it if that index is not required.
November 8, 2010 at 11:30 am
You may find this article useful.
November 8, 2010 at 10:29 am
You may find the script posted under "Maintenance Plans" section in this link useful.
November 8, 2010 at 6:07 am
Is the replication working correctly? If yes, are you backing up the transaction log at the Publisher?
November 8, 2010 at 6:00 am
This is the SPID that indicates there a few transactions to be replicated on that database
November 8, 2010 at 5:14 am
You may include some error handling in the query that you are using. TRY...CATCH would be better approach. More details here
November 7, 2010 at 10:42 pm
Agree with Lynn. Check if the ANSI_NULLS and QUOTED_IDENTIFIER options had been set to ON when the View was created.
November 7, 2010 at 10:39 pm
Viewing 15 posts - 436 through 450 (of 1,161 total)