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,...
Can we use BCP if there are text/image fields in the table? If we can use BCP then how much time would take to export and import of 600GB of tabe and...
Hi Everyone, Introduction: My company is expanding to International level and application would accept all kinds of international languages as user...
Thank you for both Satya and Mohammed. I will try this. Thanks, Bhushan Bhushan Kalla
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...
The subscriber is owned by different group and they are not ready to upgrade to SP2 unless we show the right reason and force them to upgrade to SP2...
As I mentioned in my posting, I verified both table and stored procedures and they have same number of parameters on both publisher and subscriber....
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...
Thank you very mcuh for your reply. How can we add clustered index on Distribution database? The distribution database is not an updateable database....
Hi Everyone, I would like to bring an open discussion to get the best solution for my transactional replication. Please share your personal...
I checked the mail log and it has "Databasemail process is started". It doens't show any error on log file but I haven't recieved any email from...
Separate names with a comma.
