Viewing 15 posts - 8,776 through 8,790 (of 9,707 total)
Ahha! I was taking the CAST part of the referenced article too literally. I found a different article on MS's site that references the type of query I'm...
June 17, 2008 at 5:36 am
Hmm. Interesting article. I'm going to have to play with it, though, because it looks like it won't allow me to select the column from the table directly.
Thanks for...
June 16, 2008 at 12:41 pm
There are several ways of turning this into XML. How do you want the XML document to look?
You could have everything listed as Elements in the root:
root
Element1...
June 16, 2008 at 12:22 pm
Wow. Solution is not intuitive at all, but it does exist.
Right click the actual Solution name & go to properties. Pop-up window comes up with Configuration at top...
June 6, 2008 at 1:40 pm
The steps above are the closest you can come to a practical solution.
You can also look in sysjobhistory to find out which jobs did NOT run during the time frame...
June 4, 2008 at 8:11 am
I don't know. I wish I did. I have the same issue.
I think maybe Microsoft needs to be contacted about this, but since someone else always installs our...
June 3, 2008 at 4:09 am
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
Viewing 15 posts - 8,776 through 8,790 (of 9,707 total)