Viewing 15 posts - 39,166 through 39,180 (of 39,466 total)
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
The MS site uses XML, but stores this as flat files for much of the data. The flat files are just transformed as the pages are requested. I'd recommend this...
October 24, 2001 at 9:48 am
October 24, 2001 at 9:45 am
You might be able to modify this to just display the items (or scrip them):
Steve Jones
October 24, 2001 at 9:45 am
Do they appear in the Object Browser in Query analyzer? Sorry, but I'm reaching here. not sure of the problem. Have you refreshed your table list in EM?
Steve Jones
October 24, 2001 at 9:42 am
October 23, 2001 at 2:38 pm
Viewing 15 posts - 39,166 through 39,180 (of 39,466 total)