Viewing 15 posts - 25,366 through 25,380 (of 39,958 total)
A very good DBA can get by with SQLCMD (or isql/osql), but why should they? I loved QA, which required command line work, but it also gave me many features...
February 10, 2009 at 10:38 pm
Good to know I shouldn't scan clustered servers.
I think SQL and Exchange can be finicky. Exchange has some scanners built in for content, but I think I'd be happy to...
February 10, 2009 at 10:31 pm
What do you mean by suffer? Slow down because of load?
You transfer over log records, and that takes some overhead. Not much, very little, but there is some slight overhead...
February 10, 2009 at 10:27 pm
Apart from what Jack has asked, we do that here. Articles are versioned and we have an "active version" and then all previous versions. A field signifies which is the...
February 10, 2009 at 10:25 pm
Are you restoring to the same files? Creating this many files might take time.
Why so many files, out of curiosity? Seems like extreme overkill and an admin nightmare.
February 10, 2009 at 10:24 pm
Management studio is part of the client tools. It is in the same setup for SQL Server.
February 10, 2009 at 10:22 pm
You are welcome and glad you found the issue.
As a general rule, for production, be sure you have enough space for 2 backups of all databases. These should be on...
February 10, 2009 at 10:22 pm
The deadlock manager just picks a connection and kills it. There's no "how", it does it.
You need the client to detect that there was no successful transaction and resubmit it....
February 10, 2009 at 10:17 pm
The sheet name is the table name. A CREATE TABLE statement in an Execute SQL task creates a new sheet.
February 10, 2009 at 10:16 pm
I'm not sure what you are asking here. Please be more clear with your English and ask a specific question.
It almost appears that you're wanting answers to questions someone has...
February 10, 2009 at 10:15 pm
I haven't seen these either. Perhaps someone has BackupExec or some other third party product running. Check with other sys admins.
February 10, 2009 at 10:13 pm
Do you mean execute the package twice? The variables don't maintain from execution to execution.
February 10, 2009 at 10:12 pm
How often do you need to synchronize? Is it a 2 way sync?
The issue is that VFP uses flat files, the application actually has to use DLLs to read and...
February 10, 2009 at 10:11 pm
Viewing 15 posts - 25,366 through 25,380 (of 39,958 total)