Viewing 15 posts - 4,081 through 4,095 (of 6,216 total)
I think you'd be better off looking for a good ASP site or discussion list - you should be able to determine the language from the browser I think. On...
June 6, 2002 at 5:51 am
You may find this article (and the links it contains) helpful:
http://www.sqlservercentral.com/columnists/awarren/attachanddetachagain.asp
Andy
June 6, 2002 at 5:48 am
I've never measured to see, I imagine there must be a small amount of overhead associated with each trigger, so I can see in theory that having multiple triggers would...
June 5, 2002 at 7:20 pm
Yes, use sp_addalias to alias their login to the built in dbo user.
Andy
June 5, 2002 at 7:02 pm
You should have access to all deleted info (minus text cols) in the logical deleted table inside a delete trigger.
Andy
June 5, 2002 at 7:00 pm
I havent heard of any bug that severe. Using SQL7 or SQL2K?
Andy
June 5, 2002 at 6:00 pm
Never tried it, but I imagine it would have to be dynamic sql so you would have to exec() or sp_executesql the entire construct. Stuff like this is usually done...
June 5, 2002 at 2:10 pm
Revoke is used to remove a permission previously granted to a user or a role. That means a user may still be able to access the table based on permissions...
June 5, 2002 at 2:08 pm
June 5, 2002 at 10:17 am
I'd recommend using ADO and the stream object. Try this thread:
http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=1882&FORUM_ID=9&CAT_ID=1&Topic_Title=Retrieveing%20data%20from%20Image%20field%20??&Forum_Title=General
Andy
June 5, 2002 at 8:05 am
June 5, 2002 at 8:05 am
I like the RedGate tools - I've got reviews of a couple of them posted here on the site. One will compare structures, the other with some limitations will compare...
June 5, 2002 at 5:45 am
Did you select SQL only for the subscribers, or allow others? I'd suggest trying to duplicate the error by bcp'ing the table in native or character mode.
Andy
June 4, 2002 at 5:43 pm
See if this article helps any:
http://www.sqlservercentral.com/columnists/mcurnutt/datadictionaryfromwithinsqlserver2000.asp
Andy
June 4, 2002 at 4:34 pm
Sort of. You can build up a string, then execute it using Exec or sp_executesql, like this:
set @sql=blah blah
exec(@sql)
Parens are required in this case.
Andy
June 4, 2002 at 4:33 pm
Viewing 15 posts - 4,081 through 4,095 (of 6,216 total)