Viewing 15 posts - 76 through 90 (of 1,183 total)
Silly question (maybe):
Have you tried the export from the server itself? Another workstation with SSMS installed?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 21, 2012 at 10:56 am
You have a bunch already. Go to the Character Map and explore the WingDings (and other) fonts.
Start > All Prog > Accessories > Character Map
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 17, 2012 at 8:06 am
create two different datasets. 🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 17, 2012 at 8:04 am
You're close. The parameters (when multiple are chosen) are passed to your procedure as a comma delimited list. You will need to split those out into a table of values...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 10, 2012 at 8:16 am
Why not just "try it" Set up a task to delete any *.* files and set it to run in 5 minutes, then see if it fails. :w00t:
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 27, 2012 at 7:47 am
Yes, you can update those tables, but they are "fussy".
Check out this article, it shows how to work around it. I'm fairly certain it works in 2008.
http://www.sqlservercentral.com/articles/Development/2824/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 13, 2012 at 7:27 am
You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.
According...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 12, 2012 at 10:32 am
GilaMonster (11/2/2012)
Not even with SET NOEXEC ON?
And THANKS a ton Gail! This got us on the right track at least. 🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 2, 2012 at 9:12 am
Eugene Elutin (11/2/2012)
DECLARE @sql VARCHAR(8000) = 'SELECT * FROM FROM sys.objects'
SET @sql = 'SET NOEXEC ON;
' + @sql + '
SET NOEXEC OFF;'
BEGIN TRY
EXEC (@SQL)
END TRY
BEGIN...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 2, 2012 at 9:11 am
GilaMonster (11/2/2012)
Not even with SET NOEXEC ON?
That might be it.
So how would I (or is it possible) to do this inside a procedure and capture the output.
In other words, I...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 2, 2012 at 7:46 am
Jeff Moden (11/1/2012)
Jason Selburg (11/1/2012)
I need only to check the syntax.
Also, the syntax can be...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 2, 2012 at 6:57 am
Good idea dwain, but I do not want to/ can not execute the statements.
I need only to check the syntax.
Also, the syntax can be any valid sql. So...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 1, 2012 at 8:17 pm
Ha Ha...I need to sloooooow down. I totally missed the two FROM's
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 1, 2012 at 4:11 pm
Lowell (11/1/2012)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 1, 2012 at 1:54 pm
Lee Crain (11/1/2012)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 1, 2012 at 1:20 pm
Viewing 15 posts - 76 through 90 (of 1,183 total)