Viewing 15 posts - 8,506 through 8,520 (of 9,725 total)
And also let us know what the format of your SMTP address is, please. Or give us a dummy value which represents the name of your SMTP address.
February 13, 2009 at 6:53 am
GilaMonster (2/11/2009)
Krishna (2/11/2009)
Partition could be benefited if the table is queried heavily for performance reasons
If can, but the partition function must be chosen very carefully, considering how the table...
February 13, 2009 at 6:51 am
Silly question.
Have you checked your hard drive available space yet?
The biggest problem I see regarding this, especially when the error concerns the PRIMARY filegroup, is that either the logical drive...
February 13, 2009 at 6:49 am
Are you sure you have the proper SMTP server address?
Check with your messaging team. They might have more details on the nature of the error or be able to help...
February 13, 2009 at 6:43 am
When you say that you're getting the error, is it an error that's stopping you from running your job?
If not, then I think it's more of an informational message. You...
February 13, 2009 at 6:40 am
I'm glad you like it. Good luck with your new career! @=)
February 13, 2009 at 3:58 am
That's a good question. I'll check.
I have a sneaking suspicion, though, that there's something in this scenario that the BU in question isn't telling me. Something outside of SQL Server...
January 23, 2009 at 6:09 am
Actually, Grant, I didn't know about this Template scripter. Could you give me that too?
I was going to make due with what I had, but I'd like to look at...
January 13, 2009 at 10:37 am
David's information worked.
I had to create a trace in Profiler with the Template in question (it was a homemade Template). I paused it and scripted it out. Looking at the...
January 13, 2009 at 7:29 am
Thanks for the link, David! I'll check it out ASAP.
January 13, 2009 at 6:09 am
ArkWare (1/5/2009)
Brandie,Does the "DiffShareFolderName" have any relation to the source "ShareFolder"?
Nope. As I said in my last post:
Brandie Tarvin (1/5/2009)
January 5, 2009 at 6:40 am
Actually, now that I'm examining your code, I don't think that will work for me.
What I've got is this:
\\SourceServer\ShareFolder\DB1\DB1_db_200812011600.bak
\\SourceServer\ShareFolder\MyDatabase\MyDatabase_db_200812011700.bak
\\SourceServer\ShareFolder\TempDB\TempDB_db_200812011200.bak
And all files should be copied as:
\\DestServer\DiffShareFolderName\DB1_db_200812011600.bak
\\DestServer\DiffShareFolderName\MyDatabase_db_200812011700.bak
\\DestServer\DiffShareFolderName\TempDB_db_200812011200.bak
Notice the missing subfolders. Also, the...
January 5, 2009 at 5:13 am
You say you use the string to add a folder. What happens if the folder is already there? Does it overwrite or delete & re-add?
January 5, 2009 at 5:07 am
Okay, then.
Off the top of my head, I don't know of any issues between Terminal Services and SQL / SQL Express that would require one to be installed before the...
January 2, 2009 at 10:31 am
You need to throw a Try - Catch in the script task so it throws an exception, than write the error to your job log file.
Use the following in your...
January 2, 2009 at 8:21 am
Viewing 15 posts - 8,506 through 8,520 (of 9,725 total)