Viewing 15 posts - 4,396 through 4,410 (of 7,502 total)
problem solved.
SELECT TOP 1 *
INTO #sysobjects
FROM [dbo].[sysobjects]
where 0 = 1;
ALTER TABLE #sysobjects ADD [schemaname] [VARCHAR] (48) NULL ;
-- DELETE FROM...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 23, 2008 at 11:24 am
or .... if you're allowed to do so during your update ... put your db in simple logging ...
Keep in mind..... backup before, symple recovery, your stuff in batches, full...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 23, 2008 at 10:53 am
if sqlagent is not activated you may not see sqlagent stuff.
you can use sp_configure to still have all sqlagent stuff visible.
-- enable Agent XPs
EXEC sp_configure 'Agent XPs','1'
RECONFIGURE
GO
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 23, 2008 at 10:48 am
You may need restart sqlagent to activate the first alert !
for the rest: It does not know a individual address from a group address
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 23, 2008 at 10:42 am
nailosuper (10/23/2008)
BackupMedium::ReportIoError: write failure on backup device '\\XX.bak'. Operating system error 1130(error not found).
any ideas ?...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 23, 2008 at 7:22 am
Keep in mind that the "-i" file needs to be available at the server or client where you actually launch the SQLCMD (or osql) !!
edit
this also goes for the -o...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 23, 2008 at 7:13 am
rbarryyoung (10/22/2008)
At my blog (in my signature, below) you will find my slide set and code examples of traps to avoid when setting up service Broker.
Very nice presentation indeed :w00t:
Hey...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 22, 2008 at 1:08 pm
varchar(max) is only available as from SQL2005 !
However, you can concatenate variables to execute with exec.
Here's a little example:.
EXEC (@SQLQry + @SQLQryp1 + @SQLQryp2 + @SQLQryp3 + @SQLQrypx)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 22, 2008 at 6:50 am
Indeed, service broker is a bit hard to monitor and to figure out what's going on.
You really need to play with it, to get the grips.
Here's an overview of my...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 22, 2008 at 6:39 am
Just another flash in the brain ..... or what's left of it;)
When you switched the NICs, did you rename the NIC ?
We tend to use "public network connection" for our...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 22, 2008 at 3:11 am
Forget about AWE for x64 ! Thats what it's all about with 64-bit.
You don't need that unless you go over the standard 64-bit addressing window.
However, you need to set your...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 21, 2008 at 12:57 pm
Oh indeed... I did forget to mention that !
- sqlinjection risk
- if the formula contains an error .... try to figure it out.
Be aware it may start with numeric info...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 21, 2008 at 12:49 am
Programming basics : copy/paste 😀
DBA basics: script programming :hehe:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 21, 2008 at 12:43 am
In fact, Jacks solution is better, except for the isnull testing.
There it depends if your columns are allowed to contain nulls or not.
And you should still perform :
if @@ROWCOUNT =...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 20, 2008 at 12:52 pm
you should directly move the data into your varriables:
ALTER PROCEDURE [dbo].[getSchedule]
-- Input
@facility char(2),
...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 20, 2008 at 12:49 pm
Viewing 15 posts - 4,396 through 4,410 (of 7,502 total)