Viewing 15 posts - 1,666 through 1,680 (of 2,636 total)
Not in SQL Server. The limit is 1,024 columns per table in SQL 2000.
Greg
March 8, 2007 at 9:46 am
Lee,
Tasks using the same connections are run serially because only one task at a time can use a connection. If you want to have tasks run in parallel you must have...
February 27, 2007 at 5:13 pm
Jessica,
Can you elaborate on what log file you're concerned about? Is it a database transaction log or a SQL Server error log?
Greg
February 27, 2007 at 4:38 pm
Me too. Good luck with this, Stephanie. It sounds like you're suffering for someone else's screwup.
Greg
February 15, 2007 at 4:30 pm
Those terms aren't used in SQL2000, so don't feel bad about that. BTW, there are lots of good articles about migrating and upgrading to SQL2005 on this site and on...
February 15, 2007 at 4:21 pm
Tasks are listed in Disconnected Edit in the order they were created, not in the order they execute. Workflow controls the order of execution. Is that what you're worried about?
Greg
February 15, 2007 at 4:17 pm
Sounds kind of unreasonable to rush into a migration to SQL2005. It can be a pretty big deal.
The common recommendation is to download and run the SQL Server Upgrade Advisor...
February 15, 2007 at 2:34 pm
To each his own, but I don't get why you'd use a DTS package instead of a scheduled job with the backup commands in job steps. Can someone tell me...
February 15, 2007 at 10:15 am
"I really wish all of us would learn to use the english language properly."
"irregardless"?!?
February 14, 2007 at 2:11 pm
I don't think developers need access to master. Hopefully they aren't members of sysadmin!
February 14, 2007 at 12:43 pm
Replication provides a warm standby with no automatic failover, though I seem to remember a product from CA that might provide automatic failover. Clustering and Database Mirroring are the only...
February 14, 2007 at 12:40 pm
We use the procedure that Thomas described in our shop. DTS packages are treated the same as stored procedures. Developers and users test them in dev and test, then the...
February 14, 2007 at 10:45 am
Does the account that runs SQL Server Agent have access? The package will be run in the security context of that account and it must be a domain account to...
February 9, 2007 at 10:25 am
Nirvana - Nevermind
Neil Young - Live Rust
U2 - Boy
REM - Document
Albert King - Baby, I'm in a Phone Booth
February 9, 2007 at 10:14 am
Your best bet with DTS is to import the file into a staging table that has columns corresponding to the logical fields in the flat file. Then, you can you...
February 8, 2007 at 3:21 pm
Viewing 15 posts - 1,666 through 1,680 (of 2,636 total)