Viewing 15 posts - 2,011 through 2,025 (of 2,636 total)
I don't have the motivation to telecommute. I live in a smallish city and my commute is easy. Why should I provide space at home to do my work when...
May 27, 2006 at 11:05 am
Daniela,
You should post this in the SQL Server 2005 Administration forum. You'll probably get more responses there.
Greg
May 27, 2006 at 10:42 am
We use maintenance plans for re-indexing, etc. but backups are done with homegrown jobs. We wanted to use differential backups, which aren't an option in maintenance plans. We use a...
May 26, 2006 at 12:25 pm
Additionally, Meta Data Services repository was removed as a storage option for DTS packages by SQL 2000 SP3. You'd be better off storing them in msdb's tables or as com...
May 25, 2006 at 11:06 am
Hi Aaron,
Any idea why the values are out of sync? An identity column only increments when a row is added to a table, so is it that you have different...
May 25, 2006 at 9:20 am
Look at "compatibility issues, backup and restore" in Books onLine.
Greg
May 24, 2006 at 9:13 am
johng,
Have you enabled cross-database ownership chaining for both databases? You'll need this.
A user doesn't need SELECT permission for a table that is used by a view. That's why using views...
May 23, 2006 at 4:53 pm
Apparently, the package hadn't been saved to the repository prior to adding logging. So, if you want to log to the repository, you must save the package to Meta Data...
May 23, 2006 at 4:06 pm
You'll get more information from the DTS package log. If you haven't enabled logging in the packages, do so and start the job again.
Greg
May 23, 2006 at 9:32 am
We have ours set to 8000 and 400. Haven't seen any performance problems.
Greg
May 17, 2006 at 9:24 am
If the backup file or filegroup option is grayed out in Enterprise Manager, it means the database is using the Simple recovery model. File backups can be used only with...
May 17, 2006 at 9:19 am
MG is correct, the only way to search a DTS package for a string is to save it as a VB file. BTW, packagedata is IMAGE datatype, which is binary. ...
May 17, 2006 at 9:08 am
Make sure you're setting the outer global varible in the Execute Package task to calling package's global variable and that the global variable in the child package is spelled exactly the...
May 17, 2006 at 8:52 am
Log Explorer can read logs that were created before it was installed.
DC, you might try DBCC LOG to try to decypher what's in the T-log. It's not nearly as easy...
May 16, 2006 at 4:05 pm
Your options depend on how your backup and recovery plan is set up.
Do you want the database to retain the changes made by applications and discard the changes made...
May 16, 2006 at 11:39 am
Viewing 15 posts - 2,011 through 2,025 (of 2,636 total)