Tim

I can't see how you could do this within SQL Server, since starting or stopping a service isn't (necessarily) a SQL Server operation.  I think the best you can hope...

Do you not have the table DDL and sample data to check whether your queries work and return the correct information?

The first query's not right.  It'll give you all inactive...

Is your database a contained database?  If not, you can't use a WITH PASSWORD clause in your CREATE USER statement.

John

Vijay

Those don't sound like SQL Server errors to me.  Does your stored procedure use OPENROWSET or access a linked server?  Are you able to post the code (CREATE PROCEDURE statements...

Not enough information here to give you any meaningful help.  Do some values have "KB" or "GB" instead of "MB".  What sort of comparisons do you want to do?  You'll...

Jules

Is changing the report itself an option?  If so, please post the code.  It should be fairly simple to massage the date into an unambiguous format.  I've never heard of...

I'm sure there's a PowerShell command that will remove carriage return characters from a string.  Failing that, you can do it in T-SQL with STUFF or REPLACE.

John

Additional to what?  Both versions support varchar(max) and nvarchar(max), in which you can insert a 2GB string.  If you need more than that, consider Filestream, which has been part of...

See example F here.

John

• This reply was modified 5 years, 5 months ago by John Mitchell-245523. Reason: Added hyperlink

So is CONTOSO\joe the database owner?  Use ALTER AUTHORIZATION to change the owner.  I can't remember whether that will remove your user from the database altogether - if it does,...

Erwin

You could use this opportunity to introduce some formal rules, I suppose.  Failing that, agree with users what "practical" means for each individual column, and set that as the column...

What you say is a risk can actually be seen as a benefit.  If the data is too large for the column, and the column is properly defined, you want...

I'm guessing that you want all rows that share the same values of Col1 and Col2 to have the same number, and you want those numbers to be in order...

Yes, and have users on standby to check that the user experience hasn't deteriorated in terms either of performance or feature availability.

John

A very crude way of getting uptime history without any tooling (third-party or otherwise) is to query the errorlog.  It'll only go back as far as the errorlogs do, and,...