This isn't tracked, nor is it something I think you should care about. If the index is not performing, and you need to update, most of the time this is...

Nice to hear. I think taking care of people locally is important. I'll have two chances today, as two different events out later with friends. We're buying froyo for the...

Having been to Las Vegas in the last few years, not sure a Tinyint...

I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me know...

I have to say, in this case I would use a char/varchar column for room numbers, not an int.  Even if the hotel guest rooms are all numeric, sometimes...

Cheers. Make sure you understand how this works. If you have questions, please feel free to ask.

Also, using these built-in roles isn't a problem, if the users need to see data in all tables. If they should be limited to some tables, then create a database...

Apologies, I didn't realize where your problem was. That's why showing results and desired results is helpful.

If you want the dbname in the table, you need to insert it. What...

Interesting debate. I agree that hotel room numbers are often not numerics, but strings. Numerics are used when we need some ordering, but if there wasn't a 505 on that...

I'm not quite clear what you're trying to do with #userpermission and the execute. You get to execute one statement. If you want to do a couple things, then run...

I assume this works correctly for you:

DECLARE @dbname VARCHAR(50);
DECLARE @statement NVARCHAR(MAX);
DECLARE db_cursor CURSOR LOCAL FAST_FORWARD FOR
SELECT name FROM master.sys.databases WHERE state_desc = 'online';
OPEN db_cursor;
FETCH NEXT FROM db_cursor
INTO...

There are no production builds yet.

The OP had a SPAM post.

@akhil you cannot explain this only in words. You need to provide some DDL of the table(s) structure and a few inserts to show sample...

Please follow the link in Jeff's signature and post some DDL and sample data to help us understand your structure and data.

We can "sell" PTO back to the company for pay each year. Capped at 5 days, but on the years I haven't used all mine, it's a nice benefit.