🙂 Hello Narayanan,

If I am understanding your question correctly, you can keep the sql statements in a...

Hi,

Please refer to the below:

http://social.msdn.microsoft.com/Forums/is/sqlreplication/thread/62adf53b-6506-4df4-b914-2ff299c0adf5

Even if you try to shrink the database, it will not be shrunk if it has data worth 29 GBs. So it is better to setup the autogrowth of the...

Wonderful. 🙂 Sometimes we need to...

Hello,

Not sure if you can get the info for files added/ altered alreadt but to track the changes in future, you need to configire DDL triggers to capture this information.

Check...

select @@SERVERNAME as "Server_Name" , value from master.sys.configurations where name = 'max server memory (MB)'

Hello,

Make sure the second data file belongs to 'PRIMARY' filegroup.

And then you can also try shrinking the 1st mdf file using the option 'Empty file by migrating data to other...

Have you checked this link?

http://support.microsoft.com/kb/251238

You can try the below however, this might take a long time depending on the number of records in the table.

USE YOUR_DATABASE_NAME

GO

DECLARE @MY_COL VARCHAR(50)

DECLARE @QRY VARCHAR (255)

declare kursor cursor for

SELECT...

ramyours2003 (12/3/2012)

---

i need to upgrade SQL 2005 to sql 2008 r2 where the db's are configured transactional replication .

can any one send the step by step approach who...

ramyours2003 (12/3/2012)

---

i need to upgrade SQL 2005 to sql 2008 r2 where the db's are configured transactional replication .

can any one send the step by step approach who...

Hello Ravi,

Are you able to connect to the database now?...

I guess it is because you restarted SQL Server and trying to connect to the instance from an already opened SSMS Query window.

Try this:

Right-click on query window

Goto Connections

Click on Connect...

Hello Kevin,

Please check this: http://ss64.org/viewtopic.php?id=930

Regards..

Hello Jaockim,

The error might occur if

a.) Remote connections are not enabled on SQL Server.

b.) The necessary protocols for are not enabled either SQL Server computer or the SQL Server client...