Viewing 15 posts - 37,096 through 37,110 (of 39,520 total)
I believe this is how many ADO connections work. They "prepare" a statement on the server and execute it with sp_Executesql.
What are the front end connections?
Steve Jones
July 29, 2002 at 11:54 am
Interesting. Hadn't noticed that since I tend to script things and never worried.
How big is the db and what was the original size?
Steve Jones
July 29, 2002 at 11:50 am
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
Viewing 15 posts - 37,096 through 37,110 (of 39,520 total)