Viewing 15 posts - 39,151 through 39,165 (of 39,456 total)
You can do a SET SHOWPLAN_TEXT ON before running the query to get the query plan.
Or SET STATISTICS IO ON
Steve Jones
October 24, 2001 at 10:22 pm
Ahhhhh
Sorry. I started looking at it and got distracted. I didn't see anything off the top of my head. I started testing with my own package, but didn't finish. I'll...
October 24, 2001 at 10:20 pm
off the top of my head, nothing. Can you post the ddl for the db. I'll try some experiments.
Steve Jones
October 24, 2001 at 7:02 pm
So this file does not get created?
I'm sorry for continuing to ask questions, but it is confusing in your post.
A couple things:
Are you running this from the local console on...
October 24, 2001 at 3:06 pm
Yes, there is 25 bytes. If you change to char columns, you can get to 8039. Each var column has 2 bytes of overhead.
There are 21 bytes of overhead for...
October 24, 2001 at 3:00 pm
Is the package scheduled? It runs under the SQLAgent account, so be sure that accoutn has the proper rights. When you execute it, are you clicking in the DTS Packages...
October 24, 2001 at 11:15 am
You can shell out (xp_cmdshell) and run dtsrun. You can schedule the DTS package and use sp_start_job. Or you can run the DTS package every minute and check for changes...
October 24, 2001 at 10:25 am
October 24, 2001 at 10:21 am
You would have to do as Andy said and duplicate data in a separate table.
You can index views (very similar) in SQL 2000.
Steve Jones
October 24, 2001 at 10:19 am
You can generate a database diagram. Other than that, you can script the database and look for the "constraint" keyword.
Steve Jones
October 24, 2001 at 10:18 am
How long is your timeout. There are somethings that you cannot help. Perhaps you need to tune the server or query to run faster.
Steve Jones
October 24, 2001 at 10:15 am
To truncate the table, you must be a dbo. For creating/dropping tables or databases, there are server roles for this, you do not have to be a sysadmin.
I wouldn't use...
October 24, 2001 at 10:10 am
nope, sorry but the format was changed. You can upgrade the database or migrate it yourself (using bcp or dts).
Steve Jones
October 24, 2001 at 10:06 am
A couple things. Verify that you can see the server through networking. Ping, etc.
If you are using SQL authentication, what is the protocol? If tcp/ip, verify the port is...
October 24, 2001 at 10:05 am
Haven't really noticed problems, but we haven't worked much with time. Dates are more important.
Luckily no crashes on during the switches. Since the T-log uses a numbering scheme (rather than...
October 24, 2001 at 9:49 am
Viewing 15 posts - 39,151 through 39,165 (of 39,456 total)