Viewing 15 posts - 5,341 through 5,355 (of 9,707 total)
Look at sysjobhistory in msdb. The message column will give you minimal details about failures (run_status = 0). The table seldom has the space to store all the details of...
August 12, 2011 at 6:44 am
It sounds like someone or something is removing the data source connection from SSRS.
Check the report to see where the data source connection is pointing to. Often times, SSRS will...
August 12, 2011 at 6:33 am
I don't advise shrinking it at all. The log space is growing because the database needs it.
If you're running out of hard drive space, add more as either a...
August 12, 2011 at 6:30 am
Hey, all. I don't know much about this subject (Other Wait statistics). Can anyone help this poster? He hasn't had any answers at all since he posted early yesterday:
http://www.sqlservercentral.com/Forums/Topic1158300-146-1.aspx
August 12, 2011 at 6:28 am
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
Viewing 15 posts - 5,341 through 5,355 (of 9,707 total)