That's what i am doing dear! See the BACKUP DATABASE [Outbound_Vodafone] TO DISK = N'\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak' WITH DIFFERENTIAL , INIT but it's not working.

PIEBALDconsult wrote: Sixth, abandon using stored procedures, they are nothing but trouble. That may be your opinion, but many large companies (certainly most financial institutions) insist on them for ease of deployment - if your sql is in your code (dll or whatever) and you have thousands of users worldwide, changes are far more complex than a single stored proc change (even if it does get replicated). Bob Ashfield Consultants Ltd

I do not think that that is a problem. For text fields, we use "nvarchar" so that we can cope with the German ÄäÖöÜüß. I copied some text from a web site in Hindi language into some text fields of our application. The data can be retrieved correctly - even with a SQL Server 2000.

plz check out http://msdn.microsoft.com/en-us/library/bb326356.aspx

I think this might be the cause of Unclosed connections. Always use using block and also Before you leaving the block use connection.close(). ;) And hey, you are using SQL Server Express 2005 in production environment.. :omg: This is weird. You need to keep in mind of the limitation of 4 GB Database size and 1 GB of RAM Usage. :sigh: There is as such no limitation of Concurrent Connection, but if you go on creating connections, it will soon run out of resources. Also you cant include 2 -4 GB ram because of Limitations. :( Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

Depending on your deployment, they are generally stored either on MSDB database or in the file systems. I basically use VS 2008 and MSSQL2005 and the SSIS packages are stored in drive name:\Documents and Settings\My Documents\Visual Studio 2005\Projects Or else you can also look into thru the defined projects path in Tools>Options of Visual Studio Anyway, for more details on How to: Save a Package to the File System visit this link [ http://msdn.microsoft.com/en-us/library/ms137970.aspx[^] ] How to: Save a Copy of a Package in MSDB database [ http://msdn.microsoft.com/en-us/library/ms137565.aspx[^]] Hope this helps :) Niladri Biswas

Hi Aman, Try to read this article. It is full of information. http://technet.microsoft.com/en-us/library/bb326598.aspx[^] Regards, Kaushal Arora Please Mark as Answer if it Solved Your Problem.

You were right :) "DBCC INDEXDEFRAG defragments the leaf level of an index so that the physical order of the pages matches the left-to-right logical order of the leaf nodes, thus improving index-scanning performance." I are troll :)

SQL Server tries to protect you, by remembering what you did to it's databases. Or your databases, depending on your point of view :) Read this[^] to understand why this happens. Read on here[^] for some remedies. I are troll :)

You could check that it's not a locking issue using sp_lock or sp_lock2 The need to optimize rises from a bad design.My articles[^]

sp_lock2 is a good tool for resolving lock blocks. If you find a locking issue, you can use KILL statement to kill the session The need to optimize rises from a bad design.My articles[^]

First collect the current SQL Server instance name select @@servername Execute the below queries to change the SQL Server instance name sp_dropserver ‘old_name’ go sp_addserver ‘new_name’,‘local’ go Restart the SQL Server service, to run the below commands: net stop mssqlserver net start mssqlserver

Creating an index on a view uses the normal CREATE INDEX syntax. For considerations, you should look at: Creating an Indexed View[^] Also note that this feature is in Enterprise Edition only. The need to optimize rises from a bad design.My articles[^]

How to get which process is deadlocking the system?? how to know current connections establish?? Thanks in Advance.

It's designed to decrease context switches in multi CPU environment, thus giving a little bit better performance in certain, very specific situations. Normally there's no need to use it (or at least lots of optimizations should be done before this is considered). For more info: The Perils of Fiber Mode[^] The need to optimize rises from a bad design.My articles[^]

In short, no. However, you can export the database in 2005 (scripts, csv etc) and import the data in 2000 as long as you don't use 2005 specific features or datatypes. The need to optimize rises from a bad design.My articles[^]