Viewing 15 posts - 25,336 through 25,350 (of 39,921 total)
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
Thanks, Josh. Good work.
You might want to submit this as a script using the "Contribute" link to the left.
February 10, 2009 at 10:09 pm
Database size isn't relevant. It's # of transactions that have to be sent from one to the other that create the load.
February 10, 2009 at 10:04 pm
The configuration manager is for managing services. Management Studio is used for creating databases, managing security, etc.
February 10, 2009 at 10:03 pm
The application needs to trap the error and resubmit the transaction. The deadlock manager kills the connection, so you can't do this in T-SQL.
February 10, 2009 at 10:02 pm
Do you have logging set up for the maintenance plan? It's on one of the last tabs and you can log to a disk file.
Make sure you have rights for...
February 10, 2009 at 10:01 pm
Do you mean SQL 2000? REbuildm.exe is on the CD and that will help you rebuild a new, baseline, RTM master database.
If you need to restore, you need to start...
February 10, 2009 at 9:43 pm
That sounds strange. It almost sounds like some of the SQL files are corrupt. I might uninstall and reinstall the tools.
February 10, 2009 at 9:19 pm
Viewing 15 posts - 25,336 through 25,350 (of 39,921 total)