Jared

Forum Replies Created

Viewing 15 posts - 1,981 through 1,995 (of 2,647 total)

RE: Sql agent job step - tsql command

DeanORenO (1/11/2012)
Please review the specs on RAISEERROR
http://msdn.microsoft.com/en-us/library/ms178592
I think I was misunderstanding you. Now that you have this, what is the goal? Why would you want a job to fail...

January 11, 2012 at 1:23 pm

#1432088
RE: SQL Agent Job succeeds even though step should fail

Brain fart today... Erasing irrelevant comment...

January 11, 2012 at 1:11 pm

#1432084
RE: Sql agent job step - tsql command

DeanORenO (1/11/2012)
If you know the code for this, then, please by all means put it in the thread
Oh and BTW this code does work
Interesting... So this:
IF @@ROWCOUNT = 0
BEGIN
RAISERROR('You need...

January 11, 2012 at 1:01 pm

#1432079
RE: Sql agent job step - tsql command

DeanORenO (1/11/2012)
I'm not really testing to see if a table exists or not but if rows in a table exist:
and I figured it out here is my answer for my...

January 11, 2012 at 12:55 pm

#1432074
RE: Iteration

There's actually a recent thread with some discussion on this: http://www.sqlservercentral.com/Forums/Topic1233529-391-1.aspx

January 11, 2012 at 12:47 pm

#1432068
RE: Iteration

Jason Selburg (1/11/2012)
In order to dynamically name the columns, you would need to use dynamic sql. Search BOL or this site for more details on that.
Otherwise, this gets what you...

January 11, 2012 at 12:27 pm

#1432051
RE: Sql agent job step - tsql command

I just force it to fail. SELECT * FROM tableThatDoesNotExist

January 11, 2012 at 10:51 am

#1431986
RE: Replication Lactency with out Tracer Tokens

select
pub.srvname,
sub.srvname,
publisher_db,
subscriber_db,
a.publication,...

January 11, 2012 at 10:07 am

#1431948
RE: Replication Lactency with out Tracer Tokens

We have a script... Let me find it for you and I will post it shortly.

January 11, 2012 at 9:55 am

#1431938
RE: Unable to shrink transaction log - could not locate files

jpomfret7 (1/11/2012)
USE test
DBCC SHRINKFILE(2,20)
Since we already know that the fileid is 2, go ahead and try this.
Hooray!! That worked!
Did some additional testing there must be something weird going on...

January 11, 2012 at 8:14 am

#1431817
RE: Unable to shrink transaction log - could not locate files

jpomfret7 (1/10/2012)
To be safe, you really should run against test.sys.database_files
The file name and info matches in sys.database_files, sys.master_files, sys.sysaltfiles and dbo.sysfiles...
what is the recovery model of your database?
We are in...

January 11, 2012 at 6:03 am

#1431732
RE: Few tricky Questions about SQL Server 2008 that I came across...

JagWalia (1/10/2012)
GilaMonster, thanks for replying those questions. I got these questions prior to the interview. I can see login ID question is a syntax issue and I can find the...

January 10, 2012 at 3:46 pm

#1431478
RE: Few tricky Questions about SQL Server 2008 that I came across...

JagWalia (1/10/2012)
I agree Lutz, but I am just curious to see what you all think.
Ignoring the fact that these questions and answers are not worded correctly, it is clear with...

January 10, 2012 at 3:15 pm

#1431460
RE: Very Puzzling T-SQL question

mdonald 98074 (1/10/2012)
You guys are right. I will go the route of counting my delimiters and adding 1. Thank you. Sometimes you look at something for so...

January 10, 2012 at 2:55 pm

#1431447
RE: Few tricky Questions about SQL Server 2008 that I came across...

Ninja's_RGR'us (1/10/2012)
SQLKnowItAll (1/10/2012)
Why are these tricky?
Because a lot of the right answers are actually wrong or incomplete.
I always hated those super beginner questions.
Just follow the multiple choice...

January 10, 2012 at 2:49 pm

#1431442

Viewing 15 posts - 1,981 through 1,995 (of 2,647 total)