Viewing 15 posts - 5,161 through 5,175 (of 7,191 total)
s_osborne2 (8/11/2011)
Hi,Check this:
http://msdn.microsoft.com/en-us/library/ms186757.aspx
That'll probably do the trick for you.
Thanks,
Simon
What Ashok's asking is how to start the second job only on successful completion of the first. sp_start_job will start the...
August 11, 2011 at 6:48 am
You can use dynamic SQL, but it has its pitfalls - search for "curses and blessings of dynamic SQL" for a full discussion. Why not just take the maximum...
August 11, 2011 at 4:48 am
What exact syntax have you tried, and what errors, or unexpected results, do you get when you try it?
John
August 11, 2011 at 2:30 am
What do you want to set @Retval to - CO, [DATE] or CLNG_RATE?
John
August 10, 2011 at 7:11 am
Identity property doesn't guarantee uniqueness. Did that query I posted return any rows?
John
August 9, 2011 at 8:02 am
Have you checked your data? Does the ID column have a unique constraint on it?
Does this return anything:
select ID, COUNT(*) from MyTable group by ID having COUNT(*) > 1
John
August 9, 2011 at 7:59 am
Ninja's_RGR'us (8/9/2011)
YOU'RE OUT OF ROOM OF THE DRIVE.THE END.
I'm not sure he is. If he were, I'd expect to see an error like this: Restore operation for database MyDB...
August 9, 2011 at 6:47 am
OK, so instead of saying SELECT *, say SELECT N'<TD>' + ISNULL( + '<p class="datarows">' + CONVERT(NVARCHAR(MAX),[eventtime ]),'<p class="datarowserror">Not Avail') + N'</p></TD>'
+N'<TD>' + ISNULL( + '<p class="datarows">' + CONVERT(NVARCHAR(MAX),[eventid]),'<p class="datarowserror">Not...
August 9, 2011 at 5:05 am
How are you restoring the database (GUI, T-SQL, third party), what command is being issued to do the restore, and what is the exact error message that you get?
Thanks
John
August 9, 2011 at 4:37 am
I think I'd do it by running the query in SQL and then using an Excel macro to change the name of the column.
John
August 8, 2011 at 8:51 am
Where are these results appearing - in SSMS, in an application, or in Reporting Services? This is the kind of thing that is best handled by the application (presentation)...
August 8, 2011 at 8:41 am
I don't think you can. I believe there's a utility (dtsutil?) that you can use to export a maintenance plan from one server to another, however.
John
August 5, 2011 at 7:26 am
cengland0 (8/4/2011)
Doctors in training
In the most junior hospital trainee post (Foundation Year 1) the basic starting salary is £22,412. This increases...
August 4, 2011 at 7:42 am
pwalter83 (8/4/2011)
August 4, 2011 at 7:34 am
Viewing 15 posts - 5,161 through 5,175 (of 7,191 total)