Viewing 15 posts - 271 through 285 (of 302 total)
I agree to start simple. Try running this in QA
exec master..xp_cmdshell 'bcp pubs..authors out c:\authors.txt /c /SYourServer /T'
I've seen that error before when there was a problem creating the file......
August 6, 2004 at 11:39 am
I agree that the job fails due to the DTSrun command string. Try this. Make a change to a package and create a second job to schedule it. Compare the DTSrun command...
August 6, 2004 at 11:23 am
We also use Remedy Help Desk but the tables aren't large enough yet to cause any kind of locking problem. However, you may be able to add the NOLOCK hint...
August 4, 2004 at 10:58 am
This may be of interest to you. We had a SQL 7 database (on NT 4) with a linked server to a SQL 2000 database (on W2K). The job on...
July 15, 2004 at 9:12 am
The License Logging Service on your server probably is not running. (I was able to create the same errors on our test box by shutting if off.) Start the service if it isn't...
July 9, 2004 at 12:23 pm
When I run "select serverproperty('licensetype')" I get "PER_PROCESSOR".
When I run "select serverproperty('numlicenses')" I get 4.
BOL says "NumLicenses - Number of client licenses registered for this instance of SQL Server, if...
July 9, 2004 at 11:10 am
DBCC DBREINDEX does not work on SQL 6.5. You can run DBCC CheckTable (tablename). You could also try DBCC CheckAlloc (databasename) or DBCC NewAlloc (databasename).
Linda
July 7, 2004 at 11:46 am
It also could mean that the destination path doesn't exist or is incorrect (typo?). I think I've also gotten it before when bcp.exe wasn't installed in the default directory. Try...
July 6, 2004 at 12:07 pm
Try one of these. You may need to use other date styles though.
SELECT RIGHT(DateAdd(s, 38169, getdate()),20)
SELECT CONVERT(varchar(30),DateAdd(s, 38169, getdate()),109)
We also use Cisco but the date/time field looks like 1089139787 (Greenwich Mean Time). Hope...
July 6, 2004 at 11:57 am
If you are moving to a SQL 2000 box with 'much tighter security', why not make the security the same as the original box and begin 'tightening' one piece at...
June 28, 2004 at 11:17 am
I would say "be careful". We had a database that was originally created in 6.5 and then upgraded to SQL 7 with no problems. When I restored it to a...
June 4, 2004 at 11:32 am
You could try these: Have the client reboot or Drop and re-create the linked server, but I'm not sure if either will work. Does the linked server still have a good connection? ...
June 2, 2004 at 10:15 am
Had that error too on an Oracle linked server, and was able to ask about it at a SQL Server Connections conference recently. The memory management instructor recommended that I add...
June 1, 2004 at 7:02 am
How about reading the SQL error log? Would this give you what you need?
Microsoft SQL Server 2000 - 8.00.679 (Intel X86)
Aug 26 2002 15:09:48
Copyright (c) 1988-2000 Microsoft Corporation
Desktop...
May 18, 2004 at 11:08 am
Just for fun... why don't you create a test package (on the server) and put in the piece that is failing and schedule it to run?
Linda
April 23, 2004 at 8:06 am
Viewing 15 posts - 271 through 285 (of 302 total)