Viewing 15 posts - 14,911 through 14,925 (of 18,923 total)
Yup. You can also go from florida to antartica then to the north pole and back to Fort Lauderdale to get some milk.
Or you can save the file on...
July 15, 2005 at 7:27 am
Select Name from [DbName.]dbo.SysObjects where XType = 'U' order by Name
July 15, 2005 at 7:14 am
Is there any change in the execution plan?
July 15, 2005 at 6:56 am
You have to make some sort of audit tool that takes snapshots of the sysobjects table and extract that info yourself. There's no history kept for the objects.
July 15, 2005 at 6:53 am
Here's my choice in order (for any operation, not just delete).
Exists and join (test each to see the fastest for that query)
in.
You do what you want with that. But...
July 15, 2005 at 6:48 am
I'll show you how.. but DON'T DO THIS IN PRODUCTION DATABASE
Declare @sql as varchar(8000)
set @sql = 'Select col1, col2 into dbo.' + @tblName + ' from dbo.YourTable ...'
exec...
July 15, 2005 at 6:44 am
Those views are special. They are located in master, but they can be queried from any database whitout specifying the dbname.
Ex :
use pubs
select * from information_schema.tables
use northwind
select *...
July 15, 2005 at 6:40 am
I think I'd still take a day or two to really consider the real upgrade. You can use wizards to ship the data on the server then you could...
July 15, 2005 at 6:36 am
If you want to compare results, I assume that you need to compare results for different queries on the same table so I'd just use query analyser for this and...
July 15, 2005 at 6:34 am
Correcting my post... You have to be in the db to grant permissions in it.
July 15, 2005 at 6:31 am
Can you post the image on the net.. we can't see squat if it's on your HD.
Also what is that message supposed to mean?
July 15, 2005 at 6:26 am
Those views are only located in master, but they can be queried from any database :
grant select on master.information_schema.tables to [a_db_user]
July 15, 2005 at 5:32 am
Viewing 15 posts - 14,911 through 14,925 (of 18,923 total)