Viewing 15 posts - 1,036 through 1,050 (of 1,160 total)
This query will give you the desired output
xp_servicecontrol 'querystate', 'SQLServerAgent'
November 18, 2009 at 5:45 am
This query will give you the info
SELECT
ex.UserName, ex.Format, ex.TimeStart, cat.Name, ex.Parameters, CONVERT(nvarchar(10), ex.TimeStart, 101) AS rundate
FROM ExecutionLog AS ex INNER JOIN
Catalog AS cat ON ex.ReportID = cat.ItemID
ORDER BY ex.TimeStart DESC
Ref:...
November 13, 2009 at 7:29 am
From the error message it looks like you don't have sufficient privileges on the box where you are trying to install SQL Server.
Quote from Microsoft site
Make sure you have...
November 13, 2009 at 7:21 am
Hi,
This query gives you the text used in the Stored Procedures.
select * from sys.syscomments
Filter the above query based on the requirements.
November 13, 2009 at 7:15 am
Grant them only the EXEC permissions on the Stored Procedures
November 13, 2009 at 3:11 am
Hi Suresh,
On the outset I feel that the FULL TEXT index which you might have created earlier is OFFLINE. You can try deleting it under "FULL TEXT CATALOGS" in SSMS.
This...
November 13, 2009 at 2:13 am
Hi Suresh,
What is the error that you get while taking the backup?
Regards,
Pradeep Adiga
November 13, 2009 at 1:08 am
Hi Sourav,
You may find this link useful.
October 15, 2009 at 1:17 pm
As suggested by Markus use "RESTORE HEADERONLY.." to verify that you are restoring from the right backup set. If you backup file has only one FILE, then you have to...
June 2, 2009 at 5:34 am
Try appending "REPLACE" in the restore command.
.... WITH RESTRICTED_USER, REPLACE ......
June 2, 2009 at 5:18 am
Hi Eswin,
Looks like there was some corruption in the Original database and the same is available in the backup. Hence the restore is failing. Please verify whether the backup is...
April 14, 2009 at 10:22 pm
Looks like the user with which you have logged on to SQL Server, does not have access to the path. Please check the User Permission on this share and also...
April 6, 2009 at 3:34 am
the sql stmt i run is:
(backup database Update_Master_Khasm to disk='\\10.1.5.250\Khasm\igmastback'
go )
)
Hi Salma,
In the above query you have missed the Backup File Name. Please...
April 6, 2009 at 3:14 am
Viewing 15 posts - 1,036 through 1,050 (of 1,160 total)