Viewing 15 posts - 37,396 through 37,410 (of 39,818 total)
I'd write a stored procedure that creates a temp table and fills it with the output of sp_who. Or query sysprocesses and look for the sqltrace application.
If it's not found,...
July 29, 2002 at 10:29 am
same as exec().
runs the SQL statement passed as a parameter.
Steve Jones
July 29, 2002 at 10:27 am
Hadn't noticed that, but I didn't try to apply the patches. Still trying to get a handle on the servers here.
Which patch failed?
Steve Jones
July 29, 2002 at 10:26 am
How do you move pages to the beginning of the file?
Also keep in mind you cannot shrink below the original size.
Steve Jones
July 29, 2002 at 10:22 am
Not sure. Especially if you are changing editions. I suspect you need to export the logins somehow and reimport them. Not sure you need anything else.
Steve Jones
July 26, 2002 at 12:20 pm
If you are looking for the difference between any two time periods, a subquery and self join with the item just after any item can be calculated. Helps to have...
July 26, 2002 at 12:00 pm
something like
select case when len(col) = 5 then substring(col,1,2)
else substring(col,1,1)
end 'month'
continue with the same to contatenate the day and year along with '/'. Then...
July 26, 2002 at 11:53 am
Don't think it works. I think you need Outlook or windows Messaging only.
Steve Jones
July 26, 2002 at 11:37 am
detach, backup to tape or another server, reinstall, and then attach.
Steve Jones
July 26, 2002 at 11:27 am
use substring to parse the data into a certain format and build the string that you want. Then use convert.
Steve Jones
July 26, 2002 at 11:25 am
Antares has good information. The best thing is to research and be wary. There are sometimes installation orders as well.
Steve Jones
July 25, 2002 at 4:30 pm
Doing this in a trigger essentially implements 2 phase commit between two servers, what DTC does. If your 2nd server is unavailable or the network is slow, you will not...
July 25, 2002 at 4:28 pm
On server run select @@version and reference here:
http://www.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=123
Steve Jones
July 25, 2002 at 4:23 pm
Since the logs are sequential, it's nice to have them on their own disk so the heads don't move. Do you currently have data and logs (all databases) on a...
July 25, 2002 at 4:21 pm
Viewing 15 posts - 37,396 through 37,410 (of 39,818 total)