Hi, In our environment we are planning to set up replication betwen three servers with publisher running on SERVER A, Distributor on Server B,...
Hi, I have created a login and user on the server. But I was thinking ways to create a schema when we are creating login, user , schema at one time...
Hi, I have a two files in a particular file group then when I insert 1000 records worth of data into the table A that is created on a file-group...
Thanks for your reply , Asish[:)]
Hi, I've implemented TDE for a database and Cell level encryption for a database. Here are my two question for reg these issues. 1. where exactly can...
Thanks Asish, Its working, only if I'm using like this: [ravi-pckatmai]. Thanks Ravi
Hi, I have two instances on my local machine and I have created a linked server between two instances. Name of Default Instance: Ravi-PC Name of my...
Hi, I am working as Jr. DBA, in one of the interview the interviewer asked me how would you know if the replication is broken. and how will address...
Hi all, Regarding views I have a question, when I create a view on a table and if try to delete the records from the view its deleting the records...
Hi All, I tried to implement log shipping between two servers and I was successful in implementing but at the secondary server I'm not able to copy...
Hi, I have 3 tables named employee, HR, Payroll they have similar column names in all these tables and they are under same schema and same database....
hi, Here is my table data. ShiftID Name StartTime EndTime ModifiedDate...
Hi shihab, In advanced options I had given a output text file. I have a job of 4 steps that in first step i did execute some sql statements but If...
Hi,I'd create a job that is a set of T-SQL statement( has error in this SQL commands) and I want to execute the job this results in failure of the...
Hi elisabeth,yeah I did install server 2000 and 2005 on my laptop they both are working....I really appreciate you for your kind response..Thanks and...
hi Elisabethyes, I'm trying to start SQL server from query analyze. I did not get you about SQL server running or not?If I did not start the SQL...
hi I tried to install SQL Server 2000 developer edition on vista home basic 32 bit operating system while I was installing I had error msgs like,...
hi,can anyone tell me how unique identifier differs from primary key, please.Thanks & Regards,Ravi Varma
Hi, I have installed SQl Server 2000 and SQl server 2005 on my computer. I came accross through unattended installation, and what exaclty the...
Hi, I have a doubt regarding datatype. I have a employee table where it has attributes like, emp id int, salary money, name varchar(10). I want to...
Separate names with a comma.
