Viewing 15 posts - 5,356 through 5,370 (of 9,715 total)
Linked server is exactly right. Usually, you will have a local login mapped to a remote login to provide access between servers.
Look up Remote Login Mapping in Books Online for...
August 12, 2011 at 6:26 am
IP change may affect your Foundation agents / hubs and your cluster virtual name (may need to refresh the link). Other than that, it shouldn't affect much. (I think.).
However, this...
August 12, 2011 at 6:23 am
Depends. Was SQL Server down or restarting during this incident?
If not, it's probably a network issue or the ODBC was deleted, or the users lost permissions to reach the ODBC,...
August 12, 2011 at 6:18 am
I schedule my jobs to print to an error log for each step and check Include Step Output. For SSIS packages, I use the Operating System job step format (instead...
August 12, 2011 at 6:15 am
The Dixie Flatline (8/12/2011)
Congratulations and good luck, Lynn.
Ditto.
August 12, 2011 at 6:10 am
Roy Ernest (8/11/2011)
Wonderful. Congratulations.
Thanks. @=) And thanks to everyone else, too.
Roy Ernest (8/11/2011)
August 12, 2011 at 5:50 am
sqlmaverick (8/11/2011)
I don't know how to attach the code separately.
Putting the code in a code block is relatively easy. When you post, look to the left of the text box...
August 12, 2011 at 5:43 am
SanDroid (8/11/2011)
I am only a Microsoft Certified Trainer and Red Cross Volunteer.
Wow. I'm a Red Cross Volunteer too. I teach swimming. But I'm a little confused. How does Red...
August 12, 2011 at 5:38 am
davemiller3 (8/11/2011)
Thanks for replying -Here's an update: if I remove the distinct from the statement, it runs (the cursor opens). Whatever that means !!!!
The DISTINCT keyword...
August 12, 2011 at 4:42 am
NJ-DBA (8/11/2011)
select a.country,a.zone,a.branch,a.user1 as 'user', b.user1 as user2from test a, test b
where a.user1='farooq'
and b.user1='jawwad'
Um, don't use this code. It's outdated, deprecated, and will disappear from SQL Server in the future...
August 11, 2011 at 1:23 pm
sqlmaverick (8/11/2011)
August 11, 2011 at 1:21 pm
davemiller3 (8/11/2011)
I have a cobol stored proc / assembly that runs the following code:
....
The SQL runs fine in both versions of SQL. It runs fine as an...
August 11, 2011 at 1:20 pm
Include Action Execution plan in SSMS (check under Query). Often time, execution times can be explained by the way the SQL Server db engine decides to do similar queries in...
August 11, 2011 at 1:18 pm
Grant Fritchey (8/11/2011)
Well done Brandie. The only real author I know and we still haven't met.
I think it's hilarious that you think you're not a real author.
You're writing, aren't you?
You're...
August 11, 2011 at 11:44 am
I'm published again! "Tales We'll Tell Tomorrow" is the final chapter in the Shadowrun Street Legends sourcebook. It's a novelette this time and my editor loved my fight scene.
If you're...
August 11, 2011 at 11:10 am
Viewing 15 posts - 5,356 through 5,370 (of 9,715 total)