Viewing 15 posts - 5,971 through 5,985 (of 6,215 total)
Hey Mike,
This link may be helpful:
Andy
September 1, 2001 at 6:13 pm
Simon, normally the 2 digit year is "good enough". Internally SQL stores all dates as a number, not as a string. You can test this by creating a test table...
August 31, 2001 at 6:33 pm
I dont see why not. Pretty common to use VBS to access db's/tables in web pages. Should it be done is another question!
Andy
August 31, 2001 at 6:31 pm
Xp_sendmail only sends mail, not used to configure it. Are you having trouble with the syntax for xp_sendmail, or is it failing?
Andy
August 31, 2001 at 6:29 pm
Was curious about alternatives, havent found anything really exciting. One is this bit of code from the MSDN site that uses WMI (which you may need to install, look in...
August 31, 2001 at 6:27 pm
Sorry - so far have not built a cluster (though participated in a couple and watched a lot more!) so couldnt contribute much!
Andy
August 31, 2001 at 4:58 pm
Also take issue with the idea that the only way they can fix things is with the SA password. There are alternatives. One is to give a "senior" developer SA...
August 31, 2001 at 4:55 pm
DMO is definitely the best way to proceed. I've got several articles on here if you decide to take that path. Here is some sample code to show the db...
August 31, 2001 at 4:48 pm
Hey Sergio,
The hard part is getting the data into the variable. I like to just use ADO for the entire process rather than using a stored procedure. The "old" way...
August 31, 2001 at 4:34 pm
I'd vote against doing it as well, at least on the same instance. Ideally your developers should only have to change the server name for everything to work when they...
August 31, 2001 at 4:11 pm
What kind of job? TSQL? ActiveX? By sequential do you mean that you actually waited on job#1 to complete before job#2 started, or you just started #1, then #2, etc....
August 31, 2001 at 4:08 pm
Hey Steve,
I think overall we do a fair job of keeping an open mind here at SQLServerCentral, though Im sure at times we do bias towards certains ideas or directions...
August 31, 2001 at 12:21 pm
Transactional replication with immediate updating/queued updating subscribers is one way, merge replication would also work.
Andy
August 29, 2001 at 8:44 pm
Taki, would you mind posting your final solution? Future readers will appreciate it!
Andy
August 29, 2001 at 5:56 pm
I'd agree with that - encrypting is only going to deter the casual snoopers. To me thats usually more than good enough. One of the reasons stored procs are so...
August 29, 2001 at 5:56 pm
Viewing 15 posts - 5,971 through 5,985 (of 6,215 total)