Viewing 15 posts - 37,981 through 37,995 (of 39,490 total)
You can query to see if new objects have been created. There is a create data in sysobjets. If the objects are altered, however, you cannot determine this with a...
February 20, 2002 at 3:27 pm
Not sure about the syntax for the BCP. Guess you'd need a shell of some type.
To execute another package:
Dim oPkg, intError
Set oPKG = CreateObject("DTS.Package")
oPKG.LoadFromSQLServer strServerName, , , 256, , ,...
February 20, 2002 at 1:17 pm
I wouldn't do this in a trigger. Instead, use the trigger or the original code to insert a value into some process table. Then have something that runs every minute...
February 20, 2002 at 1:14 pm
February 20, 2002 at 1:12 pm
It could be running from a COM file, a .DTS file. What is the job definition?
Steve Jones
February 20, 2002 at 1:10 pm
I do this as well and have some writing going on for this. I have a separate package that does the import for my files since all of them are...
February 20, 2002 at 10:17 am
My guess is that SQL is performing an implicit conversion. This means that SQL will attempt to automatically convert a character to an integer if that is the destination field...
February 20, 2002 at 10:14 am
Are these different formats of files? Do the names changes? If there is some pattern here you can do it. Look at the FileSystemObject. It will allow you to get...
February 20, 2002 at 10:06 am
This should be dependent on your client program. What driver/data access method are you using?
Steve Jones
February 20, 2002 at 9:56 am
If you want to "lock" a row, or series of rows in SQL Server so only one edit at a time can occur, I'd use a flag instead. It isn't...
February 20, 2002 at 9:54 am
I tend to agree with Antares. The main reason this was developed was to allow MSDE to function like access. Every app that uses it can install itself without a...
February 20, 2002 at 9:51 am
It's a nice quick way to setup backups. When I first configure a server, I often use them until I can go back and spend some time tweaking the backups...
February 20, 2002 at 9:49 am
If you have correctly troublshot the issue, I wouldn't be surprised if this wasn't a real time check, but rather data stored in a table somewhere. So you add a...
February 20, 2002 at 9:42 am
Try using a linked server. Check BOL or here:
http://www.sqlservercentral.com/columnists/rsharma/linkedservers.asp
http://www.sqlservercentral.com/columnists/bknight/linkedserver.asp
Steve Jones
February 19, 2002 at 12:37 pm
February 19, 2002 at 9:59 am
Viewing 15 posts - 37,981 through 37,995 (of 39,490 total)