speculation is that another device is blocking access to the required port. by telneting to the port the instance is listening on you can determine whether or not there...

Revenant (8/24/2011)

---

J Thaddeus Klopcic (8/24/2011)

---

Lynn Pettis (8/24/2011)

---

Jeff Moden (8/23/2011)

---

IceDread (8/23/2011)

---

Hehe, getdate() however reads the clock from windows and if you change that one you are screwed.. that sql server relies...

can the client connect to it over port the sql server listening port? you can test this from the command prompt with "telnet <hostname> <port>". try this from...

Is it just me, or is there a consensus that the 2008 activity monitor is a major downgrade from 2005? lack of the "last batch" time, open transaction count,and...

are the files you are testing with actual database backup files?

can you test on a local drive as opposed to network share?

Is the volume compressed?

The successful completion status...

apparently others are working around the problem:

(from http://www.devnewsgroups.net/sqlservertools/t34823-problem-with-maintenance-plan-delete-files-older-than-2-days.aspx)

Instead of using 'Maintenance Cleanup Task', use 'Execute T-SQL

Statement Task' and key in the following SQL commands. This should fix

the error....

Is it by chance x64 and the disk a compressed volume?

you are certain that you have the extension as BAK, not ".BAK" correct? you are certain that the files...

I seem to remember something about ending the path with a \... dont have the system in front of me to test with, but try changing the path to end...

yeah, was a restore across the network using netbackup. netbackup just got "the connection was forcibly closed by the remote host".... thing is, we restore this way lots of...

you just need to rebuild the indexes on a new data file. So, steps would basically be:

create new filegroup, perhaps "indexFG"

create new datafile on that filegroup

rebuild indexes on new...

detach/attach did the trick... no urgency to this at all any more... but still curious.

agree with previous post... you might be able to infer who was connected by looking at the default trace to see the most recent activity.

ravishankar.yedoti (8/19/2011)

---

sp_helplogins will give logins with server level permissions only........... i want to know what permission's they have at database level and object level. (with single stored procedure ...... i...

srikant_bhat (8/19/2011)

---

i am using sql server2008 express edition. i have got a problem like database is not showing after successfull login ( both mixed mode and windows mode).

a error is...

I use the following to generate scripts of the permissions for all users and roles in a database...

/**********SET RESULTS TO TEXT TO ENSURE FULL OUTPUT******/

/**

NOTE: This script should be...