RE: Migrate Jobs to New Server w/ CDW
I must've misread your post. Sorry about that. I don't have an answer for your problem with transferring the actual jobs.
2004-04-09
security
Migrating from Sybase 6
I'm having trouble with the users id's and passwords during my migration process to a 2K instance. Does anyone know of a script that I can use to BCP out?
2004-04-06
RE: dts workflow properties -- sort order
I'm not sure what you are doing. Let me suggest what I think you are saying and a solution.You have 20 steps in your package. I am going to guess that you have not used the workflow designer to join these steps. They operate in the order they were created. Now, you want the 14th […]
2004-04-06
RE: Sysprotects.columns field
Of course! I was reading the bitmask left-to-right instead of the other way round.Thanks a lot,Ben
2004-04-06
RE: Price of Auto Create Statistics
Hi Mike,SQL Server uses these stats to determine the best strategy for executing a query. If the stats are out of date, SQL Server will use these stats even though the data may have changed significantly since the stats were last updated. The choice SQL Server makes in the Execution Plan may not be the […]
2004-04-05
TEMPDB - How Do You Truncate/Re-initialize?
Hi,Environment: SQL 7 w/SP2; Production databaseMy tempdb grew from 300 mb to 13 Gb one night!! What are some ways to shrink this down to reclaim disk space? Also, is there any way to tell what is in this database that is making it so large?
2004-04-02
19 reads
RE: DBCC DBREINDEX Questions
Hi stacenic, Liked your post and would be grateful if you could post this script or email it to me on andrewkane17@hotmail.com. Regards Akane
2004-03-31
SQL Server Auditing and Notification
As Jeff says, "There are lots of articles about how to do auditing, but there are few discussions about how to use the auditing results in a real time environment". Well, now we have one that shows you how to do it!
2004-03-29
9,154 reads
RE: Error log message about TransactionDispenserInterface
This is just an informational message meaning that the MSDTC service is unavailable at the time when SQL Server is started. It won't result in any problems with subsequent distributed transactions provided the MSDTC service is available later when the distributed transaction takes place. The solution is to start MSDTC before SQL Server - by manually starting MSDTC […]
2004-03-28
Insert Trigger
Any suggestions for the following would be appreciated. I have tried a few different triggers but have yet to achieve the desired results.Table: h8summInvolved fields:hmy: primary keyhcaseworker: FK to a caseworker tablehmasterrecd: FK (to hmy) to "master" record in h8summ table The master record serves as a template for any new records. The problem is, the […]
2004-03-26
5 reads
Blogs
Enabling an Index: #SQLNewBlogger
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers