Viewing 15 posts - 9,196 through 9,210 (of 9,241 total)
the [] are commonly used to negate SQL keywords.
say you had a column in a table called object_id, to reference it as a column and not a keyword is like...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2008 at 5:12 am
this link covers logon triggers
http://technet.microsoft.com/en-us/library/bb326598.aspx
you could have the trigger check the client_host event data using the eventdata function for a known set of addresses and deny logon that way!
of course...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2008 at 3:40 am
do you mean deploy a database using a windows form or deploying sql server express using a windows form?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 4:16 pm
to attach the database, copy the files to the desitred location and use the following T-SQL
sp_attach_db 'dbname', 'drive:\path\filename.mdf', 'drive:\path\fiilename_log.ldf'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 4:13 pm
oh OK. There are advantages and disadvantages of both, the following link details rebuild vs drop and create
http://msdn.microsoft.com/en-us/library/ms189858.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 3:54 pm
starflyer (7/11/2008)
I didn't feel this stored procedure would choke on a cursor.
couldnt agree with you more
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 3:49 pm
i seem to remember this. The first release MS made of SQL 2005 SP2 had a bug with maintenance plans. Get the latest version of the SQL 2005 SP2 and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 3:25 pm
thats the way i understood it to be
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 3:19 pm
in perfmon under Memory check "available bytes" too.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 3:18 pm
i could be wrong but i get the feeling he was trying to achieve it without the use of a cursor
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 3:12 pm
BOL implies this is done on a transactional basis not a time basis?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 3:07 pm
SET @DBName = ''
WHILE @DBName IS NOT NULL
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 1:18 pm
check this info on recovery interval option
http://msdn.microsoft.com/en-us/library/ms191154.aspx
checkpoints occur for a number of reasons
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 1:14 pm
what are you shrinking data files or log files
SQL server will not shrink past an active portion of the file, if that happens to be near the end of the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 12:53 pm
or choose script to new query window then close it and save as .sql script
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 12:41 pm
Viewing 15 posts - 9,196 through 9,210 (of 9,241 total)