which version of sql server are using in your UAT server.

Is databases & Logins created by you (DBA)?

Are you using UAT server as Database Hosting server?

Hi,

You have to apply below mention script with your all database..

Syntax

USE [DatabaseName]

GO

CREATE USER [UserName] FOR LOGIN [LoginName] WITH DEFAULT_SCHEMA =schema_name

GO

EXEC sp_addrolemember 'db_datareader', 'UserName'

Script For All Databases

---------------------------------------------------------------------

USE master

GO

DECLARE @LoginName...

Plz post your table schema and sample data.

Hi,

If you comparing multiple column I suggest use CHECKSUM() funcation.

You can compare with CHECKSUM(Chartnumber, Dataofservices,CPT,Amount) and also you can compare your compete table or every row with CHECKSUM(*)

Take help from...

Hi Gail Shaw,

You are right! When I right click on .ss file and check file property it shows File Size: 50GB and Size on disk: 200MB That’s I am looking...

Hi,

What T-SQL cmds ware executed is only exists in TextData Field. Please look on it.

You have to capture StoredProcedure\SP:StmtCompleted and TSQL\SQL:BatchCompleted

Hi,

1. x64 bit Hardware and OS is batter then 32bit

2. Batter if you are using NUMA motherboard

3. Put Tempdb in RAID 0 if you using SAN

4. Separate Transaction Log files...

Hi,

In your case you have to reconfigure mirroring.

Hi,

MSDB (System Database) has role like:

SQLAgentOperatorRole

SQLAgentReaderRole

SQLAgentUserRole

You can assin a role to your user to perform SQL Agent Tasks.

http://msdn.microsoft.com/en-us/library/ms188283.aspx

What is Data Model...

Is this third party tool for designing database schema?

SQL Server have option like Generate script for Creating object schema.

Hi,

Please make sure your SSRS Service is running.

Make sure your SSRS configured properly (Default settings like Report Database, Report Manager URL, Report Server URL, Service Account etc.)

Please try to open...

Hi,

MS SQL Server does not maintain Log for specific Table. But offer option like DDL, DML Trigger but I would like to preferred Change Data Capture to achieve that for...

Hi,

1. Enable TCP/IP Protocol on both Instances

2. 1st Instance is working on 1433 port

3. for 2nd Instance Configure New port xxxx like 9125 (http://msdn.microsoft.com/en-us/library/ms177440.aspx)

4. Reset/restart 2nd Instance

5. connect 2nd instance...

Please check schema of your objects

Hi,

1. Reneme your existing table (Non-Partitioned table)

2. Created Partitioned Function, Schema and New Partitioned Table

3. Upload Non-Partitioned Table data into Partitioned Table

4. Drop Non-Partitioned table

5. Create Indexes if you wish

There...