Viewing 15 posts - 39,151 through 39,165 (of 39,717 total)
I am not sure what you mean. Can you provide more informaiton, maybe some sample data?
Why not use a CASE statement for the warehouse? I am confused as to why...
November 19, 2001 at 3:37 pm
What about checking syscolumns, information_schema.columns, or even sysobjects.
Steve Jones
November 19, 2001 at 3:36 pm
I am not sure of what else would cause a failure on the SQL side. Networking of course, must be up. If security changes, then that could cause an issue....
November 19, 2001 at 3:33 pm
Keep reading on this site. We are all a collection of DBAs and try to provide guidance and advice.
Please also feel free to email any of the authors and let...
November 19, 2001 at 3:32 pm
November 19, 2001 at 3:30 pm
November 19, 2001 at 1:28 pm
Don't know if this is a problem as I don't use replication that much. I'll ask around.
Steve Jones
November 19, 2001 at 1:28 pm
On this page:
http://www.microsoft.com/sql/howtobuy/pricing/default.asp (check out the CE section before licensing)
Looks like you can download it, but licensing is similar to the MSDE.
Steve Jones
November 19, 2001 at 10:36 am
Checked through BOL. Only shows EM and DMO as auto solutions.
For DMO: Here is the section from BOL.
Script Method
The Script method generates a Transact-SQL command batch that can be used...
November 19, 2001 at 10:33 am
Interesting debate. Haven't ever admin'd Oracle, though I did develop against v7.
Personally, it has almost always come down to cost for my companies. Oracle has been substantially more expensive. The...
November 19, 2001 at 10:26 am
It has been problematic for me. In VI 6, there were bugs with managing stored procedures. I heard these were ironed out, but haven't checked it since SP3.
Also, it only...
November 19, 2001 at 10:20 am
I'll take a look, but my guess it VB is reporting the number of rows back to the application, not MSDB.
Steve Jones
November 19, 2001 at 10:18 am
you can include them in the URL as REQUEST parameters. as far as calling form SQL, you need a client that will do this. There is an object model for...
November 19, 2001 at 10:16 am
In SQL 2000, you can use the Dynamic Properties task to change any value in the package. This can some from a db, ini file, global variable, etc.
Steve Jones
November 19, 2001 at 10:12 am
November 19, 2001 at 10:10 am
Viewing 15 posts - 39,151 through 39,165 (of 39,717 total)