Viewing 10 posts - 1 through 10 (of 10 total)
Use the Server Name instead.
July 8, 2011 at 6:21 am
I wouldn't have an answer, however I can give you some pointers to check what all the Connections are doing.
Use the SQL DMV
or use DBCC INPUTBUFFER(@SPID)
Check what is the...
July 8, 2011 at 4:20 am
The setup will be same as the Physical Servers. You just need to follow the Prerequisite as FQDN and Free Ports etc.
January 31, 2011 at 10:34 am
I do not see and issues to happen when trying Alternate Snapshot Folder for SQL Server 2005 Express.
But I believe you are aware of the Limitation of Pull Subscription in...
January 29, 2011 at 9:30 pm
Well you can use a simple update as:
UPDATE BONUS SET POINTS=POINTS+@BONUSPOINTS WHERE UID=@UID
Although this requires change in query you can use INSTEAD OF triggers to accomodate the change.
r, manish
December 30, 2008 at 3:32 am
The idea is pretty simple, follow the below steps:
1. Create a.bat and add the below content:
sqlcmd -i"C:\b.bat" -E -cEXIT -o "C:\Error.txt"
2. Create b.bat that includes the T-SQL statements:
"CREATE LOGIN...
December 30, 2008 at 3:20 am
It must have generated the snapshot but it will only apply system objects and metadata required by replication.
r, manish
December 30, 2008 at 1:28 am
The policy is applicable for SQL Server Logins. Microsoft recommends not to turn of the password policy. As documented in BOL, "Turning off this option may result in a security...
December 30, 2008 at 1:18 am
You are facing Delegation or commonly termed "double hop" issue, to troubleshoot the issue you can follow the below steps:
Verify your DNS settings
The name resolution process in Domain Name System...
December 29, 2008 at 6:52 am
If I have not misunderstood you do not want to transfer initial data new Subscriber(s). There are two ways to achieve this:
1. SQL Server Management Studio:
You can use New Subscription...
December 29, 2008 at 6:15 am
Viewing 10 posts - 1 through 10 (of 10 total)