Viewing 15 posts - 121 through 135 (of 687 total)
Got to admit that I don't have an answer for you right away and I'm not completely sure what you're trying to accomplish. I don't believe "smashing two things together"...
August 20, 2013 at 11:36 am
Thanks for catching that, I should have been a little more careful with my summary. The exact words that Microsoft uses, as Grant lead on, says
A common table expression...
August 16, 2013 at 12:50 pm
A Common Table Expression is a temp table with the scope of a single DML statement. There's all kinds of cool ways to use them but the basic syntax is...
August 16, 2013 at 12:04 pm
A-Rod has appealed and Big Mo blows 3 saves in a row.
You guys see this? Hidden Ball Trick
Too funny, made me look up other occurrences of this trickery and I...
August 12, 2013 at 12:21 pm
Boston and Tampa Bay are 1-1 in this current series of 4. We gotta win out!
July 24, 2013 at 2:04 pm
Man, every time I post in here I think "where's Ray?"
Braun, what a disappointment. Everyone gave him the benefit of the doubt and here we are two years later looking...
July 24, 2013 at 6:56 am
xp_delete_file is an undocumented extended procedure. Google it for parameters and usage.
Please fully understand the risk involved when using undocumented procedures before implementing them in any environment.
July 23, 2013 at 12:18 pm
Try putting the .bak in the data directory with all your other MDFs if possible.
July 23, 2013 at 9:40 am
and the service account has permissions to the file and folder?
July 23, 2013 at 9:01 am
1: make sure the path really does exist via windows explorer
2: make sure the service account has proper permissions to the folder/file
3: make sure YOU have proper permissions to run...
July 22, 2013 at 12:48 pm
Perhaps some table definitions, test data, and expected output?
July 22, 2013 at 12:12 pm
Your issue is probably file permissions. Try running a script to restore the database and see if it errors out, look for "Access Denied" or "Can't find the file path...
July 22, 2013 at 11:39 am
Steve Jones - SSC Editor (7/11/2013)
First hit of 2013. Mr November is back
Back? As in, back on the DL? 🙂
Where the heck did the Rays come from? Holy cow! Last...
July 22, 2013 at 7:54 am
So confusing.
You've restored from a backup successfully.
You've attached the .mdf file successfully (what about the .ldf?)
Seems like it should all work but your application cannot connect.
Have you remapped the users...
July 19, 2013 at 1:21 pm
Viewing 15 posts - 121 through 135 (of 687 total)