Viewing 15 posts - 16 through 30 (of 49 total)
Try sqlping and see if you can ping the server...is the PC in the SAME domain as the your server?
http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx
...Michelle
September 1, 2006 at 1:07 pm
Can you PING his PC or remote desktop to his PC to get the files? You could use the sp_attach_db proc to recover it...
Just trying to grasp for ideas...
September 1, 2006 at 12:37 pm
September 1, 2006 at 12:30 pm
For sql 2005:
log_shipping_monitor_alert (Transact-SQL)
Stores alert job IDs for log shipping.
log_shipping_monitor_error_detail (Transact-SQL)
Stores error detail for log shipping jobs.
log_shipping_monitor_history_detail (Transact-SQL)
Stores history details for log shipping...
September 1, 2006 at 12:26 pm
What exactly are you trying to do? You can map the drive and access the files that way...
can you use sqlcmd to access the server?
sqlcmd -?
Please EXPAND on what...
September 1, 2006 at 12:19 pm
September 1, 2006 at 10:50 am
Maybe these links will be useful:
http://searchsqlserver.techtarget.com/general/0,295582,sid87_gci1194281,00.html
http://www.databasejournal.com/features/mssql/article.php/3595276
Thanks...Michelle
September 1, 2006 at 10:45 am
Use sp_helpgroup to see who are already members of the group...
use dbname;
sp_helpgroup (list all groups\roles that are defined in the database)
sp_helpgroup 'awsadm' (list info about the MEMBERS in the that...
September 1, 2006 at 10:27 am
See this thread...
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=584081&SiteID=1
It includes this MS article:
http://support.microsoft.com/kb/320027
Hope this helps...Michelle
September 1, 2006 at 10:05 am
Found my answer...YES - THEY CAN...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetdep/html/netfxcompat.asp
September 1, 2006 at 9:41 am
ISSUE RESOLVED...
sqlmaint.exe"" -S MYSERVER -D dbccpagetest -UpdSts -RmUnusedSpace"100"
Thanks...Marsha
August 17, 2006 at 11:08 am
If you are coding via T-SQL, you can use the "WAITFOR DELAY":
Example pulled from BOL:
WAITFOR DELAY '00:00:02'
SELECT EmployeeID FROM AdventureWorks.HumanResources.Employee;
SYNTAX:
WAITFOR
{
DELAY 'time_to_pass'
| TIME...
August 17, 2006 at 6:25 am
Maybe granting "db_datareader" role will solve your problem...
http://qa.sqlservercentral.com/columnists/bkelley/sqlserversecurityfixeddatabaseroles.asp
August 16, 2006 at 7:12 am
August 15, 2006 at 3:26 pm
This thread may help as well...
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=168425&SiteID=1
August 11, 2006 at 12:12 pm
Viewing 15 posts - 16 through 30 (of 49 total)