Viewing 4 posts - 346 through 349 (of 349 total)
Thanks for the lead in Frank (my mistake) -- I modified the OBJECTPROPERTY to filter on 'IsUserTable' instead of 'Customers'
April 4, 2005 at 7:18 am
All I need to do is determine the existance of a TABLE. Then I do a:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Customers]')
and OBJECTPROPERTY(id, N'Customers') =...
April 4, 2005 at 7:10 am
Good suggestion! Exactly what I recommended BUT the lead developer wants to build an .MSI type application whereby they can bundle all scripts together on a CD and create, via...
April 1, 2005 at 9:32 am
To allow access to XP_CMDSHELL:
o grant execute on the XP_CMDSHELL (in the Master DB) to your SQL User (or SQL Role)
o then, determine if a SQL Server Agent Proxy Account exists:...
March 23, 2005 at 12:19 pm
Viewing 4 posts - 346 through 349 (of 349 total)