Viewing 15 posts - 3,211 through 3,225 (of 7,429 total)
The big security factor is that you grant execuion rights to the SP and as long as the ownership chain is the same you do not have to grant any...
March 17, 2003 at 3:17 am
On average you will find Stored Procedures faster and more flexiable. The primary reason is some business logic can be there requiring less work if client is an executable to...
March 14, 2003 at 1:01 pm
Not sure when the will put back out. The reason it was pulled because of Slammer was because the Trial Version cannot be patched (it is disabled against this). If...
March 14, 2003 at 4:29 am
Same as normal restore except you list all files like so.
RESTORE DATABASE x FROM disk='\\server\share\backupname1.bak',
disk='\\server\share\backupname2.bak',
disk='\\server\share\backupname3.bak'
etc.
The reason it is faster is because each object gets it's own thread and connection to...
March 14, 2003 at 4:05 am
Take a look at this thread it may be the same issue. http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8062&FORUM_ID=9&CAT_ID=1&Topic_Title=MSDE%202000%20Install%20on%20Win%20XP%20fails&Forum_Title=General
March 14, 2003 at 3:56 am
I don't think MS worries about certifing against SPs just against the OS. It works perfectly on both from the point I am using it and about 100 instances exist...
March 14, 2003 at 3:48 am
The key to multicast and broadcast is if the router is configured to handle the traffic. If it is explicitly not then it will not send the data across.
March 14, 2003 at 3:42 am
You could setup SQL to run a job every minute to check if you want to stay strict SQL. Or you could write a small app with a thread that...
March 14, 2003 at 3:38 am
Be carefull of duplicating your posts. See/leave replies in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=10597&FORUM_ID=8&CAT_ID=1&Topic_Title=selecting+a+rowcount+where+it+doesn%27t+exist%2E&Forum_Title=T%2DSQL
March 14, 2003 at 3:35 am
Unfortunately this is not handled any direct way in SQL at this point.
Like you said, cursor and temp tables work or add an IDENTITY column to the table. Or add...
March 14, 2003 at 3:34 am
I would say it depends most on how long you need to retain the data. If a short period like a few years then a backup should suffice. If however...
March 13, 2003 at 3:59 am
Please do not cross post. See/leave repliees in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=10569&FORUM_ID=20&CAT_ID=2&Topic_Title=Migration+in+SQL+6%2E5+to+2000+using+a+powerbuilder&Forum_Title=Connecting
March 13, 2003 at 3:53 am
Please do not cross post. See/leave repliees in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=10569&FORUM_ID=20&CAT_ID=2&Topic_Title=Migration+in+SQL+6%2E5+to+2000+using+a+powerbuilder&Forum_Title=Connecting
March 13, 2003 at 3:53 am
WHat type of connection method are you using? If ADO then it try an updated MDAC that is compatible with 2000. I believe is a limitation in the connector you...
March 13, 2003 at 3:52 am
Please do not cross post. Duplicate message, see/leave responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=10574&FORUM_ID=9&CAT_ID=1&Topic_Title=Installing+Sql2000+on+windows+xp&Forum_Title=General
Edited by - antares686 on 03/13/2003 03:39:02 AM
March 13, 2003 at 3:38 am
Viewing 15 posts - 3,211 through 3,225 (of 7,429 total)