Since you already have the linked server have you tried just using the fully qualified table name with a normal Insert or Update query? IE: UPDATE LEAVESBOX.YourDB..YourTable SET Field = 'blah' WHERE Foo = 1 OR INSERT INTO LEAVESBOX.YourDB..FOO VALUES(...) Gary Johnson Microsoft Natural Language Group DBA, Sr. DB Engineer
2003-08-07
Can this be converted to a function? That would involve replacing the sp_executesql statement with an xp_ statement. spring, summer, fall now dawn breaks on cold, white magic Winter's chill is nigh
2003-08-06
1 reads
quote: I needed to load one SQL Server 6.5 database into SQL Server 2000. You have to perform upgrade from SQL Server 6.5 to 2000. quote: Also can we have SQL Server 6.5, 7.0 and SQL Server 2000 on the same machine?! If you have SQL Server version 6.5 installed, you can keep the SQL […]
2003-08-06
Question: I tried this using mssqlserver -c -m. The DOS information sais the server is running in single-user mode, but when I connected with Enterprise Manager, it still had the single-user grayed-out. How do you actually restore the Master DB? regards,
2003-08-06
Yea, that is pretty much it. I at one time was curious on trying fibers in a C++ app I was playing with and when I got to reading I pretty much decided there was no guarantee in what I did unless I am a dran good C++ programmer and I am far from that.
2003-08-05
quote: You can use sp_spaceused @table_name which gives various bits of information about a table including the number of rows and is probably quicker than select count(*) from .... However, it is not always accururate but you can correct the information with sp_spaceused <table_name>, 'TRUE'. I forget when it gets out of sync with the […]
2003-08-05
1 reads
2003-08-04
Philip, It uses less CPU, but it has rounding issues just like all the other "Cast(Cast(@date as int) as datetime)". Any time over 12 Noon and the day is rounded up. However... cast(substring(cast(@date as binary(8)),1,4) + 0x00000000 as datetime) ...Has no rounding issues at all. And, as long as you put your code in a […]
2003-07-31
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-31
quote: 1. I originally wrote it as a single select. Unfortunately, the view has nolocks so SQL Server would put together the view first and then get information from the audit table, which was changed at the same time the view was put together, and join the data, which was then out of sync. As […]
2003-07-31
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
By James Serra
A TON of new features announcements at the European Microsoft Fabric Community Conference help...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers