Viewing 15 posts - 4,696 through 4,710 (of 7,185 total)
You need to set up a linked server on the server on which you create the proc.
John
February 15, 2012 at 5:36 am
Formatting is something that's better done in the presentation layer. However, if you insist on doing it in the data layer, just convert the number to varchar(4) and concatenate...
February 15, 2012 at 4:02 am
Mithra
Soon after SQL Server starts, there is a message in the errorlog something like "The NETBIOS name of the local node that is running the server is 'NODE1'. This is...
February 15, 2012 at 2:34 am
Are we talking about a cluster server here? You can look at the Windows event log and see whether any particular start of SQL Server occurred on the same...
February 15, 2012 at 2:08 am
Also, I would strongly recommend using different domain accounts for test and live servers. Think about it - at the moment, everything that your live server has access to,...
February 15, 2012 at 2:02 am
No they shouldn't. A table is an unordered set. The database engine will retrieve rows from a table in the way and in the order it judges most...
February 14, 2012 at 5:01 am
Appalled? I usually reserve that reaction for earthquakes, famines, wars and so on.
In any case, I don't agree that just because two statements are posted on the same page...
February 14, 2012 at 4:30 am
The only (easy) way I can think of for achieving anything like that is to use sqlcmd and pipe the output into your text file.
John
February 14, 2012 at 4:04 am
A header and a footer? I'm out of my depth now. Sounds like something you'd user Reporting Services for. Do you have a sample of what the...
February 14, 2012 at 3:48 am
Sounds like you're being taught to run before you can walk. Those are columns, not rows.
SELECT col1, col2, col3 FROM MyDB.dbo.USERS
John
February 14, 2012 at 3:34 am
Does this mean it works?
You tell me - you have access to the file; I don't.
John
February 14, 2012 at 3:32 am
You haven't read about fully qualified object names, have you? Nor have you read Phil's suggestion properly. The only way your code will work is if you have...
February 14, 2012 at 3:30 am
Are you sure tm37_1_2_online isn't the database name, because dbo sounds like the schema name. Just swap it round with dbo and it should work.
As a bit of background...
February 14, 2012 at 3:22 am
Unless the USERS table exists in the default database for your user, you will need to qualify it with the database (and maybe also schema) name:
SELECT * FROM MyDB.MySchema.USERS
By the...
February 14, 2012 at 3:12 am
Viewing 15 posts - 4,696 through 4,710 (of 7,185 total)