Viewing 15 posts - 2,521 through 2,535 (of 6,679 total)
June 13, 2018 at 1:03 pm
June 13, 2018 at 12:00 pm
If using windows accounts - then all you need to do is add the user to the database, do not create a login. The login will be created only on...
June 12, 2018 at 3:22 pm
You have a couple of options:
sp_describe_first_result_set
IF 1=0
SELECT ... FROM ... WHERE -- this should return and define all columns that would normally be returned
June 12, 2018 at 12:53 pm
Is the instance setup as an FCI (failover cluster instance) - or AlwaysOn?
When installing an instance for FCI - the clustered resource will have an IP address and...
June 10, 2018 at 9:42 am
This isn't really that hard - the most difficult part is identifying 'duplicate' rows. Using a CTE or derived table - add a row_number() and partition by tableID (and any...
June 4, 2018 at 12:30 pm
Evict the DR node from the cluster - and verify the storage is available. Install SQL Server exactly the same as you performed on the FCI nodes - that is,...
May 31, 2018 at 3:41 pm
May 29, 2018 at 1:49 pm
Were you logged into the system with a login/user that only has the role 'PaleoDataHost'? If not - then whatever permissions the login/user was granted is what will be utilized. ...
May 28, 2018 at 9:08 am
What Edition of SQL Server? If you installed the Express Edition - that does not support SQL Server Agent and the service will not start.
May 24, 2018 at 3:31 pm
May 22, 2018 at 2:31 pm
port 2433 is not listening
unable to telnet to that port
port 1433 is...
May 21, 2018 at 12:42 pm
1) Check fragmentation on the clus index. If...
May 18, 2018 at 11:48 am
May 15, 2018 at 11:27 am
I have a stored procedure which inserts and updates millions of records in a table...
May 8, 2018 at 12:53 pm
Viewing 15 posts - 2,521 through 2,535 (of 6,679 total)