Viewing 15 posts - 46 through 60 (of 87 total)
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?
November 18, 2010 at 5:46 am
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...
November 18, 2010 at 5:33 am
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...
November 18, 2010 at 4:56 am
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...
November 17, 2010 at 5:51 am
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
October 30, 2010 at 3:47 am
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...
October 30, 2010 at 2:47 am
Hi,
In your case you have to reconfigure mirroring.
October 28, 2010 at 8:49 am
Hi,
MSDB (System Database) has role like:
SQLAgentOperatorRole
SQLAgentReaderRole
SQLAgentUserRole
You can assin a role to your user to perform SQL Agent Tasks.
October 18, 2010 at 5:11 am
What is Data Model...
Is this third party tool for designing database schema?
SQL Server have option like Generate script for Creating object schema.
October 18, 2010 at 4:46 am
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...
October 18, 2010 at 4:20 am
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...
October 15, 2010 at 6:26 am
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...
October 6, 2010 at 11:40 pm
Viewing 15 posts - 46 through 60 (of 87 total)