Viewing 15 posts - 7,906 through 7,920 (of 9,643 total)
jagpalsingh4 (8/15/2008)
I have login as sql admin
Doesn't sound like it on this server. Is the msdb database on-line? The only time I have seen a problem like...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 15, 2008 at 7:59 am
Sounds like a permissions issue. What account is this script running under?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 15, 2008 at 7:50 am
Are you hiding the whole report or just the details row? When I have hidden the details row I have never seen a blank area.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 15, 2008 at 7:49 am
We've all been there. Just yesterday I was fighting with using a variable in SSIS for an Excel connection and it was because I had mispelled the file name...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 15, 2008 at 7:48 am
fixfox8 (8/15/2008)
It is in my question "very large database[/u] file more then 2TB"
I have learned in my close to 3000 posts on this site, that the reason someone has posted...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 15, 2008 at 7:46 am
I don't know if this will work with 2005, but there is a custom extended stored procedure called xp_smtp_sendmail available here that worked great in 7.0, 2000. Your other...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 15, 2008 at 7:27 am
If the file does not have free space you cannot shrink it. Does the file have free space? Is it a database file or a log file?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 15, 2008 at 7:23 am
I did not mean for you to disable remote connections, I was just commenting that they do not need to be enabled when you are on the console. Since...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 15, 2008 at 7:20 am
Are you sure that the SQL Server is SQL 2000? This script works fine on SQL 2005 as well. I don't have a 7.0 server to try it...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 15, 2008 at 7:16 am
I think you are asking how to assign a null value to a parameter in ADO.NET. So that is what I am going to answer.
You would do something like...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 15, 2008 at 7:10 am
My current employer would pay for training as needed if I can show a need for the project(s) I am working on. I value training highly and that is...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 15, 2008 at 7:06 am
Don't know how the big sites do it. Probably something like full-text query and some highly proprietary stuff as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 15, 2008 at 6:56 am
If you are running SSMS on the console then you should not need remote connections enabled. Try localhost\instance.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 15, 2008 at 6:51 am
If I understand what you are saying you want to parse the formula to get the names of the inputs for the formula. You should search this site for...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 15, 2008 at 6:48 am
You should look at snapshots. Check out BOL for this. There is not a native way to read and query backups, there may be a tool out there...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 15, 2008 at 6:42 am
Viewing 15 posts - 7,906 through 7,920 (of 9,643 total)