Viewing 15 posts - 37,411 through 37,425 (of 39,720 total)
You could use DTS to either alter the package (hard) or generate a filename and rename the generated one (easier).
Look for the filesystemobject on MSDN and that will point you...
July 9, 2002 at 9:40 am
Ran this on SQL 2000
declare @i char(3)
select @i = 'ZZZ'
select @i
select @i = rack
from racks
where 1 = 0
select @i
I still get 'ZZZ' both selects. I suspect your data...
July 9, 2002 at 9:29 am
50000 and above are reserved for user defined errors.
If you can post more info, we might be able to help.
Steve Jones
July 9, 2002 at 9:27 am
I've seen some issues with Terminal Services and running some apps. Can you run other MMC apps, like Event Viewer, Manage, etc.?
I'd search technet for the error.
Steve Jones
July 9, 2002 at 9:26 am
Can you post the code you are having issues with?
Another alternative is to use an ActiveX script in DTS to move or copy your files.
Steve Jones
July 8, 2002 at 5:20 pm
You would have to correlate the current time with the job schedules to determine which is running.
Steve Jones
July 8, 2002 at 5:12 pm
It will capture all statements run against the server.
Steve Jones
July 8, 2002 at 5:06 pm
A great suggestion for something to write about 🙂
I don't have a resource, but the basics would be the same for each server:
1. hardare
2. software, including current settings (SPs, what's...
July 8, 2002 at 5:02 pm
I agree with danw. Set a standard port per instance for your company and use it.
Steve Jones
July 8, 2002 at 4:58 pm
look in msdb.dbo.sysjobschedules. You can query from here.
Preferred: sp_help_job
Steve Jones
July 8, 2002 at 2:16 pm
Not having had this situation, take this with a grain of salt.
I try to "loosely couple" things together. Why? So failures to not cascade. Also, updates, upgrades, etc. do not...
July 8, 2002 at 1:51 pm
One would think so. It may depend on what you are changing. I'd guess that 100 int cols is similar to 10 int cols. For varchar, you may introduce page...
July 8, 2002 at 1:41 pm
Profiler will work.
Not aware of anything else that is "select" based. Log Explorer will capture the INSERT, UPDATE, DELETE stuff.
Steve Jones
July 8, 2002 at 1:39 pm
if it's the same structure, write a query to get the data you want to move, i.e.,
select Col1, Col2, Col3
from BigTable
where Col1 >10
Once you have your queries,...
July 8, 2002 at 1:38 pm
Viewing 15 posts - 37,411 through 37,425 (of 39,720 total)