If the table is not in the result set of the two queries then the table doesnt exist.

Are you sure its a table and not a view?

If it is a...

My script does not put NULL in the columns it puts a 0

declare @table table (accountno nvarchar(10),trans char(2), amount int)

insert into @table values ('a1414141','Cr',12334),

('A64646','Dr',4500),

('E3636','Cr',900),

('R9494','Dr',8000)

SELECT

AccountNo,

CASE trans WHEN 'Cr' THEN 'Credit' WHEN...

Side by side, by either

1. A new server with the same instance name, then follow the steps on how to rename the host of a sql server to change it...

Based on the OP's first post on this here they dont have backup's, that is if its the same database in question.

I would do that as a side by side upgrade, but check that you are not using any enterprise only features first

SELECT feature_name, feature_id

FROM sys.dm_db_persisted_sku_features

...

that is a sql query

The only way would be to disable the second processor in the BIOS or remove the processor from the server.

Changing affinity settings doesnt allow you to reduce the number of...

If you could please read the second link in my signature on posting code, data and expected results it will help us out greatly.

But based on what I think you...

I also read it as being Yes as the question didnt specify needing to delete or not delete the other snapshots, so in theory Yes I can revert to any...

Anyone know where you can purchase Innis & Gunn's by the case load?

Looked at the local cash and carries but they dont stock it.

Use UNC paths with admin shares as default (eg \\SERVER\D$\Folder) but this will require administrator access to the SQL Agent account

Or share the folder as \\SERVER\Folder but lock it down...

Side by side or in place upgrade?

Yes it is possible, but will depend on what you need to call the SQL server, downtime etc etc?

Is Express installed as a named...

As with anything licensing, it is best to speak to MS directly or contact your MS reseller.

General rule of thumb is anyone who accesses a development SQL server must have...

This is data collector and the management data warehouse.

I would first start by checking the configuration, under management - data collection - (right click) management data warehouse.

EXEC sp_srvrolepermission 'dbcreator';

EXEC sp_dbfixedrolepermission 'db_backupoperator';

DBCreator can only restore while db_backupoperator can backup.

Easiest thing to do is add the user to the model database with db_backupoperator and then when a new...