Viewing 15 posts - 26,716 through 26,730 (of 39,792 total)
How are the jobs running? You might check the client configuration utility for the default protocols.
October 13, 2008 at 8:12 am
Please post in the correct forums. Move to SS2K Admin
October 13, 2008 at 7:44 am
Mike has contacted me and should be sending me some code. Not sure if it's more than attached above, but I'll get it posted and drop a note in here.
October 13, 2008 at 7:42 am
Those numbers are likely falling. Given the recent banking issues, seems like we're getting less and less bank offers in the mail every day. Less stuff to steal.
October 13, 2008 at 7:21 am
As of now, no one really knows. I'm not sure if this is SQL 11 or SQL 10.5 right now.
October 12, 2008 at 7:26 pm
And be sure you know what columns are in the index before you drop it.
October 12, 2008 at 7:25 pm
Read books online for the parameters for the create index command. You might want to note the fillfactor before you do this.
October 12, 2008 at 7:24 pm
Good resume
Good backup
you only need one.
Get Log Rescue, I think it works on v7 as well. Read the logs. Then go get backups setup.
October 12, 2008 at 7:23 pm
You don't need to use robocopy. Copy the files manually.
October 12, 2008 at 7:21 pm
Are there people connected to the database?
If you want to move the files, detach the database, be sure you kill the users from it, and then attach it from the...
October 12, 2008 at 7:20 pm
Pathing is based on the server, not the client. you might need to copy the file to the server.
October 12, 2008 at 7:16 pm
The way you have this written it's not checking uniqueness, it's checking for an inquequality.
I think you want to check
if exists( select id from table where start= @start and...
October 12, 2008 at 7:15 pm
If you ever have an issue from the warehouse, then you'll have to whack the snapshots and you'll lose them. While they're a nice way to get the snapshot, I'd...
October 12, 2008 at 9:58 am
You have written bad code in your scripts and are not properly checking for validation of parameters.
http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/
October 12, 2008 at 9:04 am
The SQL Server security service needs rights to start the service. Or a service. This isn't necessarily granted by default. You'd want to set an account for the SQL service...
October 12, 2008 at 9:03 am
Viewing 15 posts - 26,716 through 26,730 (of 39,792 total)