capn.hector (5/7/2012)

---

what i expected...

How did you find that 100 blocking had occurred?

Have you tried package config file?

SQL Server does not force you to add these columns.

It may be your company policy. If it is your company standard, you need to follow it.

In my previous company, we...

tkathpalia (5/4/2012)

---

I am having issues with setting up Databases for Replication. When I setup a Publication and Subscriber the MSubscriptions table has a status of 3 for the database...

Try OPENROWSET/OPENDATASOURCE

Looks like the SQL Server service account does not have enough privileges to start service on the remote server.

JayK (5/6/2012)

---

So my question is will there be any issue for our transactional replication when our Publisher/Distributer (Production) servers are on RTM and our Subscriber is on SP1 CU4.

Or is...

I think it is normal. I think you...

USE AdventureWorks;

GRANT CREATE TABLE TO MelanieK;

GO

Try -F (first row) and -L...

I think update statistics can be...

1) EXEC sys.sp_configure N'awe enabled', N'1'

GO

RECONFIGURE WITH OVERRIDE

GO

2) EXEC sys.sp_configure N'max server memory (MB)', N'12288'

GO

RECONFIGURE WITH OVERRIDE

GO

3) Grant Lock Pages in Memory rights to the Service Account

k.subramanyam1017 (5/2/2012)

---

I know the logshipping concept but i don't know the server failures in logshipping if you know pls answer my question. everbody gave suggestions but no one gave...

What do you mean by "SQL server Agent not working"? Do you mean SQL Server Agent service is not running?

Or do you mean SQL Server Agent service is running, but...