Viewing 15 posts - 27,196 through 27,210 (of 39,793 total)
That will create a bunch of stuff in text files, but it won't get it into SQL Server.
It would help if we knew what the OP wanted to accomplish.
September 6, 2008 at 8:13 pm
Look for something open in tempdb as well. The database should be in simple mode, so it should clear the log at each checkpoint.
September 6, 2008 at 8:09 pm
If SQL Server is running, meaning the service is running, can you connect to "(local)"?
Also, it installs under Program Files, look for the SQL Server log files, and you will...
September 6, 2008 at 8:08 pm
There is no SQL Server mode. There is mixed mode, both Windows and SQL authentication, and Windows only mode, for only Windows authentication.
There is no default user and password. The...
September 6, 2008 at 8:05 pm
That's what I'd think. You have another process already setup for log backups, and that will interfere with log shipping. If you log ship, you basically need to disable other...
September 6, 2008 at 7:14 am
Most of this stuff you would get from a command line or WMI if you wanted it. SQL Server would then access that the same way, with an XP_CMDSHELL or...
September 6, 2008 at 7:13 am
Downtown isn't very big. Within 3 or 4 blocks, there are lots of restaurants. Just don't start walking uphill 🙂
September 6, 2008 at 7:11 am
I'd prefer the SSIS stuff myself, though it would be more work. Replication will do it, just remember that there will be a time the table is not available as...
September 6, 2008 at 7:11 am
The Blackberry server might not like something. I'll check with a few people.
September 6, 2008 at 7:09 am
Shouldn't be temporary files. Wouldn't delete them. Maybe you had a space or typo in it.
September 6, 2008 at 7:07 am
Yikes, this thread is skirting the edge.
September 4, 2008 at 9:54 pm
It may or may not. Depends on what checkdb needs to do, the activity and resources available at the time it's run, etc.
September 4, 2008 at 9:53 pm
We have a fix in testing for this. They're not supposed to show future dates, but they do.
September 4, 2008 at 9:52 pm
The search came with the forums and I'm not sure it includes username. I think it only searches the content, which isn't great. However the "My Posts" should help.
September 4, 2008 at 9:51 pm
For yourself, set up a technical blog today. It's free, and even if you never post, just try it. Andy has gotten me to think about it regularly, like setting...
September 4, 2008 at 9:50 pm
Viewing 15 posts - 27,196 through 27,210 (of 39,793 total)