Silverfox

Forum Replies Created

Viewing 15 posts - 811 through 825 (of 1,136 total)

RE: Are the posted questions getting worse?

havent we got enough of those already:-P, although any new MVP's are always welcome.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 11, 2009 at 12:57 am

#1052092
RE: Undocumented Extended Stored Procedures

if you do sp_helptext and mention the extended stored procedure name you will get the DLL name as long as it isnt an internal extended stored procedure.
sp_helptext ExtendedStoredProcedure
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 10, 2009 at 9:51 am

#1051807
RE: how to delete database in restoring../suspect mode

llokshin (9/10/2009)
Hi, we tried to restore a database and it failed with this error
This operation failed with errors.
Restoring RP02P (database) from:
H:\MSSQL\backup\rp01p\rp01p_db_200909090500.sqb
SQL Server error
SQL error 9003: SQL error 9003: The...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 10, 2009 at 9:42 am

#1051801
RE: Undocumented Extended Stored Procedures

You will not be able to see the code for these, unless someone has kindly disassembled the DLL that they are in, and placed them on the net.
If anyone has...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 10, 2009 at 9:33 am

#1051795
RE: stored procedure execution error

John Marcuz (9/10/2009)
When I tried to execute 'sp_OAMethod' procedure in SQL 2005, i got the error as '[SQL-DMO] This cache contains no result sets, or the current result set contains...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 10, 2009 at 9:09 am

#1051775
RE: side by side SQL Clusters

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/c0a2e17e-a944-4190-b2cd-3a9aaefd4103
http://www.eggheadcafe.com/forumarchives/SQLServersetup/Jan2006/post25072107.asp
that is all i could find :unsure:, it does imply that you cannot, but I know it is pretty weak.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 10, 2009 at 9:01 am

#1051767
RE: What would be the apt certification?

You dont mention which version(s) of sql server that you work with, but in your position I would be tempted to go for the microsoft certification that focuses on BI...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 10, 2009 at 8:50 am

#1051754
RE: The EXECUTE permission was denied on the object 'sp_send_dbmai

jabba (9/10/2009)
A support analyst need to be able to send email via the sp_send_dbmail command. When he attempts to run a script using his existing permissions he receives this...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 10, 2009 at 8:38 am

#1051745
RE: script

ramyours2003 (9/10/2009)
can any one send me the script likefinding dbname ,db owner,date created,size, space avaialble ,dboptions, no.of users, last backup, last diff backup, tran backup, maint.plans, space allocated by...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 10, 2009 at 8:24 am

#1051737
RE: IBM OLEDB Linked Server Connection Error

If you have recreated everything exactly the same. I would check connectivity to the other server.
can you ping it from the server you are having trouble with. sometimes network glitches...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 10, 2009 at 8:11 am

#1051730
RE: Maintenance Plan job failing (sometimes) with connection failure

Filipe Miranda (9/10/2009)
Hi,
As part of our MP in one of our instances we have a transaction log backup that runs every hour on the hour. That job runs fine almost...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 10, 2009 at 8:03 am

#1051719
RE: Adding an instance to a SQL 2k5/Win 2k3 cluster - can I use the same disk resources?

Matt Cherwin (9/10/2009)
One of the instances I maintain is a SQL 2005 (Standard, 64-bit, SP2) installation on a 2-node Windows 2003 R2 (Enterprise) cluster, using SAN disk for storage. We're...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 10, 2009 at 7:43 am

#1051714
RE: Failed Maintenance Task

hmmm, interesting, looks like the checkcatalog part of the dbcc checkdb has reported catalogue dependency errors, against system objects.
Really need someone else to confirm...
but I think using sp_refreshsqlmodule might help,...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 10, 2009 at 6:26 am

#1051683
RE: Visual 2005 / SSIS

Silverfox (9/8/2009)
clucasi (9/8/2009)
Is the version of Visual Studio 2005 that is installed with BIDS have the ability to create web applications, if so is there a way we can limit...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 10, 2009 at 5:49 am

#1051672
RE: SSC Points

seems to run very slow at times especially in the mornings GMT. still 350 points out on forums 😀
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 10, 2009 at 5:44 am

#1051670

Viewing 15 posts - 811 through 825 (of 1,136 total)