You can use the DMV sys.dm_os_performance_counters. This DMV gives you the performance monitor’s counters in a table format. The query bellow shows how to get the memory that...

I admit that I didn’t work with full text search for a while, but from what I remember it won’t help you at all. Full text search is beneficial...

You can create a stored procedure that references none existing objects. The procedure will be created, but you’ll get a runtime error if you won’t create those objects before...

You can use the noeds and value XML methods together in order to get the information in tabular format. If you’ll do it in a CTE, you’ll get the...

Can you post the CREATE table statements with insert statements that insert some data and then show the XML that you want to get? This will make it much...

Db_woner is the name of a role that anyone it can do anything inside the database. If you want your users to have limited permissions (as they should), then...

I should have paid attention more carefully to the question. It isn’t enough to change the in direction to queryout direction. You also have to specify the parameters’...

It seems to me that you are using wrong direction. You specified in your command line the direction as in. I think that it should be queryout.

Adi

One important different between granting permission on all existing objects and granting permission on the schema level, is the behavior when a new table is created at the schema. ...

Elliot is correct. If you have a conflict and a user belongs to different groups that gives him deny and grant permissions on the same object, the deny permission...

Don't forget that the size that you get from sp_spaceused included the size of all files including the log files. Check the physical size of all database's files and...

You have to move the log writing to the place that handles the errors. If it is the application, then you’ll have to use the application’s code to write...

You can’t rollback a database into a state that it was before the backup was taken. If the only full backup that you have is from October 18, then...

You have to be more specific about your problem. Log shipping has nothing to do with publication. Publication has to do with replication. Also you are writing...

Can you create views with the appropriate columns and let the user work with the view instead of the table?

Adi