Viewing 15 posts - 8,776 through 8,790 (of 9,701 total)
Glad you figured it out. @=)
May 30, 2008 at 5:58 am
There are so many reasons there could be such a size difference. There are a lot of "things" in SQL 2005 that causes a database restored from 2000 to...
May 30, 2008 at 4:37 am
Wait a minute. Did I read that right? You can't make any changes with the SA account either?
Have you checked the Server's Event Log (Security) to see what...
May 30, 2008 at 4:32 am
Check with your Active Directory Admin to see how the Windows Account is set up. Does it require the password to be changed on a regular basis?
Most likely, it...
May 30, 2008 at 4:30 am
We did it in a scripted job. Unfortunately, we use Litespeed for our backups, so posting my code wouldn't help you unless you also use Litespeed. Basically, though,...
May 30, 2008 at 4:25 am
Oh, and regarding the BACKUP LOG... Truncate_Only option...
Under the simple recovery model, performing a checkpoint removes the inactive part of the log without making a backup copy. This truncates the...
May 30, 2008 at 4:18 am
This is what BOL has to say regarding TruncateOnly:
TRUNCATEONLY
Releases all free space at the end of the file to the operating system but does not perform any page movement...
May 30, 2008 at 4:14 am
Do you actually have permissions to see ALL the databases on the servers? It could be, if you're not using a SysAdmin account, that you just can't see it,...
May 30, 2008 at 4:10 am
PD,
It's set to false. But it doesn't change the fact that I can't set the Deployment Utility at all for the SSRS project, which is the problem. The...
May 29, 2008 at 4:37 am
That's a nice little trick, Frank. Thanks for the suggestion.
Unfortunately, it doesn't quite work for my setup. Apparently when you put an SSRS project in a solution with an...
May 28, 2008 at 7:46 am
Shaun,
I think you might be missing the point slightly.
I don't need parens around the first part of the statement because that statement will always be true and I want it...
May 27, 2008 at 11:06 am
The code is correct, however, I think (and I haven't had a chance to test it yet because I'm solving other problems) the issue is the difference between the datatype...
May 27, 2008 at 11:01 am
I'm not sure a function is needed for an insert. The left outer join suggestion is a good one, though.
Usually what I do is...
Insert into MyTable (col1, col2, col3)
(Select...
May 24, 2008 at 8:38 am
Thanks for the info, jjarupan. I'll take a look at it. @=)
May 21, 2008 at 5:10 am
FYI: Todd's solution worked for getting rid of the #13119 error message on the toolbox.
Of course, it took a while for VS to reinitialize the toolbox after I...
May 20, 2008 at 5:51 am
Viewing 15 posts - 8,776 through 8,790 (of 9,701 total)