Hi Everyone, I would like to modify the "Database default locations" in Database settings under server properties using T-SQL script. The easy way to...
Hi, I am trying to use BCP Utility to copy data from flat file to SQL Server 2005 server table. The flat file has "comma" as field and "next line" as...
Hi Everyone, I setup database mirroring between two NAMED instances on two different servers. After completeing the database mirroring configuration,...
Hi Everyone, Introduction: My company is expanding to International level and application would accept all kinds of international languages as user...
Hi Everyone, I come accross a strange situation in database that I was not able to drop a foreign key constraint using the T-SQL script (even with...
Dear Friends, I have a transactional replication set up in my environment and it's running fine. Now I wanted to add a new article (Table) to the...
Hi Everyone, Transactional replication has been setup and running perfectly from OLTP to Data warehouse servers in my company and there are no...
Hello Folks, I need help to add a table "TABLEB" to a publication in the transactional replication. The transactional replication was already set...
Hello Folks, We recently set up replication on SQL Server 2005 and it's working fine till yesterday. We added a new column to the published article...
How to find what are the existing logins in the SQL Server instance and also how to find what fixed server and database roles are to the logins in an...
Hello Everyone, I load data every day from Sybase to SQL server 2000 and sybase database has some special characters in the database. I never had...
Hi Everyone, For efficient user permissions managebility in SQL Server 2005, I wanted to create Windows NT groups and add those groups to SQL Server...
Hi Everyone, I would like to bring an open discussion to get the best solution for my transactional replication. Please share your personal...
Hi Everyone, I just set-up DBmail in SQL Server 2005 to get the notifications about my scheduled jobs. It works fine some email accounts but the...
How to change database operating system file name through T-SQL command? For example, I want to change the below data file name from "FILENAME =...
Hi Everyone, I am having problems with Development box “MyDatabaseServer†in setting up as Distributor. When I am configuring as Distributor...
I just got into SQL Server 2005 and loading data from SQL Server 2000 databases. I have many data sources running on SQL Server 2000 and need to be...
Hi Everyone, We are migrating from SQL Server 2000 to 2005 so my job responsbility is to migrate the DTS packages to SSIS packages (.dtsx). I...
Hi Everyone, I have a 3 node cluster group with Active/Active/Active configuration. Let us assume that node names are Server1, Server2, and Server3....
Separate names with a comma.
