Hi, Can anyone help me on how to set a trigger in SQL 2005 by date and time, so that when the period occurs, I can change a value in another column...
Hi, I have a small question. Is it possible to alter only some portions of the data within a column instead of modifying the entire data in that...
Hi, I'm looking for a stored proc for monitoring the activities of my databases and SQL error logs. Can someone help me with this please? Thanks...
Hi, I'm new to clustering so a couple of novice questions. 1)Do I need to have windows 2003 in cluster mode prior to installing a 2 node sql2005...
Hi, Does anyone know how to convert a column showing birthdate to number of years? For example creating a query which will only show data in the...
Hi all, I have a wierd problem and have googled everywhere for an answer without any luck. My SQL Server 2000 sp3a has both SQL and WIndows...
Hi, Our network services people are about to install a new version of Zenworks. The Configuration manager requires a database to communicate with....
Hi, Did anyone come across this error when trying to check the Securables option within the Login Properties of a SQL 2005 userid?...
Hi, My apologies if this question has been answered before in some other forum and also if this is not the right forum for this question. We are...
Hi, Would anyone be able to tell me how I can retrieve the last modified date from a table in SQL Server. I'm not sure which system table to query...
Hi, Please can anyone explain that why does all my SQL jobs do not run, when I change the server role for the SQL BUILTINAdministrators Loginid, even...
Hi, I'm running SQL 2000. I have created a Linked server connection between the SQL server and a Sybase server. Prior to that I have installed the...
Hi, Pretty basic question. Is it required to restart the SQL2000 Server instance after changing the sa password? Thanks
Hi, A Very Happy New Year to all the members of SQL-Server-Performance Forum. A slight dilemma. I have saved my DTS packages in Visual Basic format...
Hi, How do I remove the inactive servers that show up when I run the command "OSQL -L"? I have deleted those servers that were initially registered...
Hi, I have to create a second instance on an already existing SQL server 2000 install. It already has service pack 3a applied. Can I install this...
Hi, I'm running SQL Server 2000 standard edition on a Windows2003 Server with 4Gb RAM. SQL2000 Standard memory limitation is upto 2GB. Can I use the...
Hi all, In my organization we have an application (FIS) which runs on Sybase 12.5. We are currently implementing a new application (FB) running on...
Hi, I'm having a wierd problem with MSSQL2000. I have installed MSSQL2000 server sp3a standard edition on a standalone server. The instance selected...
Hi, I have 2 SQL servers, both on the same domain. Both the SQL servers are using Mixed mode authentication. I'm a part of the BuiltinAdministrators...
Separate names with a comma.
