Viewing 15 posts - 706 through 720 (of 1,157 total)
Agree with ALZDBA. Most likely your server does not have E drive or the folders that is being referred to in the screenshot.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 30, 2010 at 8:21 am
Yes. You can do it in SQL Server 2000. 'allow updates' should be 1 in sp_configure and after creating the stored procedure all you have to do is modify the...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 30, 2010 at 7:50 am
The database which are OFFLINE cannot be shrunk. Alter your query to exclude those offline files or bring the databases online for your query to work fine.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 30, 2010 at 4:16 am
TDSSNIClient initialization failed with error 0x5, status code 0x51. Reason: Unable to configure MDAC-compatibility Named Pipes protocol pipe name in registry. Access is denied.
This is because the access to registry...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 29, 2010 at 10:56 pm
You may find the document mentioned in this discussion useful.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 29, 2010 at 11:02 am
Is there any way inside the DB2.dbo.usp_Proc1 SP to determine that the current database of the connection that called it is DB1? (I've done some Googling and couldn't find any...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 29, 2010 at 4:39 am
You may find these discussions useful.
http://www.sqlservercentral.com/Forums/Topic941445-391-1.aspx#bm941974
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 29, 2010 at 4:35 am
You may find these links useful
http://www.sqldev.org/sql-server-replication/sql-server-2000--log-reader-not-working-65684.shtml
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 28, 2010 at 12:25 pm
Instead of Mapping the drive, why not backup the database to the network share directly? An example here
However, it is recommended to backup the database locally to disk and then...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 27, 2010 at 5:00 pm
TRY....CATCH is an option
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 25, 2010 at 11:18 pm
SQL Server does not maintain a password policy of its own. It is dependent on the Windows Password policy
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 25, 2010 at 1:30 pm
I am not sure if we can control the file naming convention in Maintenance Plans. If you want to change the naming conventions, use custom scripts. Some good examples are...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 25, 2010 at 1:28 pm
Did the server name change after cluster installation?
Please check this these links help
http://support.microsoft.com/kb/307336
http://support.microsoft.com/default.aspx?kbid=328306
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 25, 2010 at 1:13 pm
Yes, that looks like a better option to me.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 25, 2010 at 1:07 pm
Please check the System Event Log at the time of this issue. Most likely there will be some errors related to Active Directory not being reachable.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 25, 2010 at 1:04 pm
Viewing 15 posts - 706 through 720 (of 1,157 total)