Viewing 15 posts - 37,336 through 37,350 (of 39,763 total)
You could use a while loop to build the results, but it might be ugly if this is large.
I'm sure there is something, but can't think off the top of...
July 29, 2002 at 12:02 pm
If these are in two tables, then you need two delete statements.
To delete the msgPopup,
delete msgpopup
FROM msgPopup INNER JOIN msgInfo
ON (msgPopup.msgID = msgInfo.msgID)
INNER JOIN msgMessage
ON (msgInfo.msgID = msgMessage.msgID)
WHERE
Sender...
July 29, 2002 at 11:56 am
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
Viewing 15 posts - 37,336 through 37,350 (of 39,763 total)