New answers tagged

3 votes
Accepted

how to find out the free space inside a database file when the database is not online?

However, how can you do that when the database is offline? There really isn't an option built in to do this as the allocation management items are in the database. The databases would have to be ...
Sean Gallardy's user avatar
3 votes
Accepted

what sql server is holding in the used memory?

[...] is there a way to find out what sql server is holding in there memory? Yes and no, depending on what you mean by "holding in there memory" (sic). If you mean what's using memory in ...
Sean Gallardy's user avatar
3 votes
Accepted

RESTORE DATABASE - The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time

I remember I had similar problem during the database restore, in my case it were reporting queries that run every 15-20 min and took tens of gigabytes of RAM for memory grants, as well as some extra ...
Aleksey Vitsko's user avatar
0 votes

SQL Full-text Filter Daemon Launcher failing to start with error "Access is Denied"

After trial and error, I found that in my case: The SQL Full-text Filter Daemon Launcher (MSSQLSERVER) service failed to start due to the following error: \r\nAccess is denied Was due to installing ...
David's user avatar
  • 1
-5 votes

list of users, logins ,permissions,account active ,last login date for SQL Server

Yes. Look at views in master database.
White Owl's user avatar
  • 727
2 votes
Accepted

Convert numbers to words | Spell out DECIMAL USD 1259.75 as 'One thousand two hundred fifty-nine dollars and seventy-five cents'

Modify the 100/1000/1000000 "WHEN" portions of the SELECT statement to be like this, and you should achieve your desired result. WHEN @Number BETWEEN 100 AND 999 THEN dbo.NumberToWords((...
Craig's user avatar
  • 136
0 votes

DBmails are not working after modifying the sp_send_dbmail procedure

Sounds like self inflicted wound. I think now you have 4 options: Restart the instance and hope it will work (You haven't said you did it already) Fix the procedure yourself Alter the procedure to ...
rois's user avatar
  • 549

Top 50 recent answers are included