Hi Adriaan, You wrote a scheduled job, but the user wants to use a trigger. Do you think it will be easier for the user to maintain if it were a job...
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...
Thanks Greg. I have downloaded the tool and will be testing it in our environment. Cheers
Thanks. Much appreciate your reply. Cheers
Thanks to everyone who gave me suggestion to my problem. Frank's query worked and I was able to resolve my problem. Apologies for this late reply as...
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?...
Thanks for the reply. Regarding my question, presumably not if you don't have the software assurance agreement from Microsoft. In our case we don't...
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...
Thanks for the reply guys. I have conveyed the responses to the user who was asking me the question. Appreciate your time on this. Cheers
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 All, Sorry for the trouble. Kindly ignore the question I posted. I have found the reason for this anomaly. My SQL Server agent was connecting...
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...
Thanks for your replies. And sorry for not getting back earlier. I was able to do a workaround the problem, by using the Sybase ODBC driver and then...
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...
Separate names with a comma.
