Viewing 15 posts - 436 through 450 (of 1,157 total)
Does executing the below query generate any errors?
xp_cmdshell 'dir c:\xxx\yy\zzz\filename.xls'
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 9, 2010 at 3:27 am
Does the folder "c:\xxx\yy\zzz" exist on the server where SQL Server is running?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 9, 2010 at 3:18 am
These screenshots should help you to read the SQL Server Error Log.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 8, 2010 at 11:30 am
You may find this article useful.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 8, 2010 at 10:29 am
You may find the script posted under "Maintenance Plans" section in this link useful.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 8, 2010 at 6:07 am
Is the replication working correctly? If yes, are you backing up the transaction log at the Publisher?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 8, 2010 at 6:00 am
This is the SPID that indicates there a few transactions to be replicated on that database
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 7, 2010 at 10:39 pm
Viewing 15 posts - 436 through 450 (of 1,157 total)