I am limited in my testing environment, so I am trying to validate my findings via this post. I am trying to understand: (1) if the size of the log file affects backups? (2) if the free space in the log file affects backups? I am not sure how to test for #2 above, but in my tests regarding #1, if I run a backup ... 22 Jul 2010 08:07
Getting a LockMatchID error using sp_rename
When I'm trying to rename a table in the tempdb table, I'm getting an error when I run it in a stored procedure or code, but it works ok on MSSMS. I get the error: Invalid EXECUTE statement using object "Object", method "LockMatchID". EXEC sp_rename 'Tempdb.dbo.oldFile' , 'newFile' Don't ask me why I have to ... 14 Jul 2010 18:45
Paging Size set up for sql 2005 best performance
erver windows 2003 sp1. 64 bits, Paging file size for selected drive C is (custom selected) Initial 2046 MB, and maximum 4092 MB. It is currently allocated 4081 MB. Computer RAM memory is 8GB. Server functions as a database MS SQL 2005 server, and it is used under heavy insert database operations The pro... 19 Jul 2010 17:59
Distributed Transaction on SQL 2005
A stored procedure running from server A database db1 updates both local tables, as well as, remote ones, on server B database db2 via a db link. All updates are part of the same distributed transaction. I have got it to work on one server. In other words, I have made all provisions to make this work like tu... 15 Jul 2010 17:39
database integrity checks failing
Hello: We have two database integrity checks jobs in SQL 2005 that are failing. One job is for our financial app databases, while the other is for the SQL system databases. I know how to conduct the typical fix for the financial app databases--run DBCC CHECKDB to find the questionable tables that require t... 15 Jul 2010 05:33
still learning of the sql command HOW TO DISABLE XP_CMDSHELL AND DISABLE BOTH MAIL PROCEDURES ... 14 Jul 2010 03:22
Did this ever get resolved?
I am having the same problem since moving my server to the AD domain. Davey wrote: MS SQL Server Service Login Credentials Lost on Reboot 12-Mar-07 I am running 2003 Server and I require the SQL Server 2005 service to use a specified AD user account (named SQLUser), when I edit the service properties and ... 13 Jul 2010 15:21
Provider: Named Pipes Provider, error: 40 & error 53?????????????
Problem: How can I access SQL server on WAN???????????????????????????????? ----------------------------------------------------------- Error: (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) ------------------------------------------------... 15 Jul 2010 17:39
ANN: Database Workbench 4.0.3, the multi-DBMS IDE now available!
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: " Database Workbench 4.0.3 Pro " This release includes the FREE Lite versions for InterBase, Firebird and MySQL. Version 4 introduced full Unicode support, 4.0.3 fixes some issues foun... 13 Jul 2010 10:54
How can I connect from SSMS
hi, I am having 2 logins from my domain. one is normal user and another one is domain admin. domain admin is in ITAdmins group, which have SQL Connection as sa to connect the SQL Instances. I need to log in to my laptop always with normal user only (security policy). I am using DOMAIN\Myname accout to conne... 14 Jul 2010 03:22