Viewing 15 posts - 9,196 through 9,210 (of 9,244 total)
are you using redundant HBA's? It would be advisable
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2008 at 2:58 pm
change this
create proc procname
@subject1 int,
@subject2 int,
@subject3 int,
@result int output
as
set @result = @subject1+@subject2+@subject3
to this
create proc procname
@subject1 int,
@subject2 int,
@subject3 int,
as
declare @result int
set @result = @subject1+@subject2+@subject3
it will only expect 3...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2008 at 2:47 pm
are you using a static or dynamic IP address for the windows 2003 server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2008 at 1:08 pm
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
Viewing 15 posts - 9,196 through 9,210 (of 9,244 total)