Viewing 15 posts - 376 through 390 (of 966 total)
Alternatively why can't you just keep the SQL Agent Monitor open? You can set auto refresh for whatever frequency you would like (i.e. 10 sec, 30 sec, etc.) and add...
July 23, 2013 at 3:35 am
Can you connect through another client? What happens when you try and connect via sqlcmd? Is the SQL Browser service running? Is this a named instance?
Just trying to cycle through...
July 15, 2013 at 8:08 am
It is for adding metadata to a database or objects within a database. Can be used for documentation of a database that stays with the database no matter where installed.
July 15, 2013 at 3:08 am
The phrase "i am trying to mirror the database" is a little ambiguous. Are you trying to make a copy of a database with schema/data from one instance and setup...
July 15, 2013 at 3:04 am
For replication there written "Subscriber only", instead of requiring replication Agent
You can search by key word Replication
Different agent. The original post is about the SQL Server Agent, not agents...
July 15, 2013 at 1:56 am
Make sure when you run that query you change the database your in to match the one your querying information about. Otherwise you will get information that might not be...
July 12, 2013 at 6:14 am
I have same problems, visit this link;
http://technet.microsoft.com/en-us/library/cc645993(v=sql.105).aspx
There is written that SQL 2008 R2 Express support for Replication "Subscription only"? but can not be used.
Is this reply to the correct forum...
July 12, 2013 at 4:07 am
Is Excel installed on the maching hosting SQL?
Can you post the PowerShell script and the entire error message?
July 12, 2013 at 4:01 am
You will get plenty of errors connecting to linked servers if security is not setup correctly. If you are trying to use impersonation you need to ensure SPNs are registered...
July 12, 2013 at 2:57 am
Not sure what you mean by "the login front-end". Is this the SQL Server or another server? What happens if you open up a query window in SSMS and run...
July 10, 2013 at 6:24 am
And when SQL is on the other cluster node the query does not come through malformed?
July 10, 2013 at 1:38 am
Where are the invalid T-SQL statements coming from? Unless it is some internal queries that the DB engine is doing I would imagine that all T-SQL would be coming from...
July 9, 2013 at 5:49 am
Joie Andrew (7/8/2013)
TempDb is used for several things in SQL Server. DBCC CHECKDBs, temp tables, row versioning, etc. If TempDb keeps getting to 2GB in size I would say that...
July 8, 2013 at 8:20 pm
Viewing 15 posts - 376 through 390 (of 966 total)