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...
August 15, 2008 at 7:59 am
Sounds like a permissions issue. What account is this script running under?
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.
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...
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...
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...
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?
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...
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...
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...
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...
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.
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.
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...
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...
August 15, 2008 at 6:42 am
Viewing 15 posts - 7,906 through 7,920 (of 9,643 total)