Hi all, Is there a way I can modify the system stored procedure such as sp_addlogin.
Hi all, Is there any setting I can do to have minimum password length in sql server user.
Hi... Can I set expiry date on the SQL Server user name and password like what we have in Windows login.
After reading all so many comments about the Transaction log backup, seems that backing up transaction log is a very important step in maintaining...
Can you see the SP_MSins_table1 stored procedures in server2. I noticed that the stored procedures will be created at the subscriber automatically...
I found the solution. CALL sp_MSdel_SUN$Cust_ Ledger Entry can be changed at the Publisher properties - Article tab.
{CALL sp_MSdel_SUN$Cust_ Ledger Entry) statement is generated and executed by SQL Server in the background. I have no idea from where the...
Hi all, I hit the error 'Syntax Error or Access Vialotion'. The command that caused the error is CALL sp_MSdel_SUN$Cust_ Ledger Entry. I get the...
My apologize... it is the sqlserv.exe that takes up the memory. It takes up 230MB of memory while the sqlagent.exe only takes up 4MB. I noticed...
I have published a Transaction publication in my Sql Server 2000. In order for the replication to work, I have to start the sql server agent service...
Separate names with a comma.