Viewing 15 posts - 6,451 through 6,465 (of 7,185 total)
Abhay
I don't really know. I take it both databases are on the same server?
Do you get the same error if you just do this? SELECT * FROM QISPD.dbo.visitInfo
What...
March 27, 2007 at 6:16 am
Abhay
So it sounds like visitInfo doesn't exist in QISPD, or if it does it's not owned by dbo, or maybe you don't have permissions on it. Or perhaps you have...
March 27, 2007 at 5:05 am
Abhay
Assuming both abc tables have an identical structure and are owned by dbo:
INSERT INTO QPR.dbo.abc
SELECT * FROM XYZ.dbo.abc
John
March 27, 2007 at 4:23 am
The order of the rows in a table has no meaning in a relational database system. Does your table have a primary key constraint? If so, you can order by...
March 26, 2007 at 4:39 am
"I don't know why management studio only shows fisical drives, and not mapped drives"
I imagine it's because the drive is mapped in the context of your login and not in...
March 26, 2007 at 3:37 am
Happycat is right - backing up and then restoring to a different location is the best way. However, I don't think detaching and re-attaching will work, since I believe this...
March 26, 2007 at 2:58 am
Adrain
Right-click on your server in Enterprise Manager and choose Properties. The server collation appears on the General tab.
John
March 23, 2007 at 9:55 am
Certainly not the best way of doing it, Anders, but since you and I have both asked how he decides which duplicate rows to keep and haven't had a proper...
March 23, 2007 at 9:34 am
Anchelin
I imagine the error is in this line:
set @ServerName =(Select distinct ServerName,AppName from BEPSQL01.DBA_Reports.dbo
March 23, 2007 at 4:31 am
San
If the three columns in your sample data are all part of the primary key, then those rows aren't duplicates. You're going to need to change the design of your...
March 22, 2007 at 10:28 am
San
Which four columns is your PK defined on? There are only three in your sample data.
John
March 22, 2007 at 10:07 am
True, depending on the requirement. Sometimes you are only interested in the size of a number, which, in the case of a scalar, means its distance from zero. For example,...
March 22, 2007 at 9:50 am
San
How are you going to choose which row(s) to eliminate and which one to keep? If you search this site for eliminating duplicates or something similar, you will find lots...
March 22, 2007 at 9:09 am
David
What are the exact commands you are using in your application and in Query Analyzer?
John
March 22, 2007 at 9:06 am
Viewing 15 posts - 6,451 through 6,465 (of 7,185 total)