If this not a live server then would suggest re-starting SQL server services from the surface are configurator after enabling TCP/IP.
What does this job do is it possible for you to post the script ?
There are many ways to do this it depends if the task needs to be performed with downtime or should be done without it. With Scheduled downtime...
Below is useful script written by SQL DBA in one of the forums which kills processes hanging around more than 5min , you tweak that further. But...
Your indexes are small , anything beyond page count 10K and having AVG fragmentation > 30% needs attention. You needs to answer couple of questions...
- Have 8GB of RAM and enabled AWE on SQL server , is PAE switch enabled on the OS level. - Have you checked fragmentation level of indexes on the...
Check the DDF table sysindexes by querying the system table for this index. -Sat
Hi All, Been while .......... RTM term is used by Microsoft to differentiate the OEM binaries from the general first deployments before service...
A mirrored database is not available for access , since it is in "recovering" state which implies that system databases can not be mirrored and is...
Excerpt from link below states, Active Directory can be accessed from SQLSERVER 2005 by using: Linked Server OpenRowSet Managed Stored Procedure...
Hi All, It was today made a visit to the link http://msdn.microsoft.com/en-us/library/ms144262.aspx , one item in list which caught my attention is...
Last link about management by application middle tier is nice, most roles and security is defined at application level in business logic layer and...
If you mean SQL IO as DISK IO then you need to look the counters in perfmon as listed below Avg. Disk Queue Length <=2 Avg. Disk sec/Read < 0.002...
Do not clearly understand your question , could please rephrase your question. -Sat
can you check if you can connect to SQL server 2008 using simle ODBC test at operating system level ? If you are not encountring any error messages...
If you are refering to this http://en.wikipedia.org/wiki/TSX-Plus then how does that relate to SQL Server database ? Are you planning to migrate for...
- has anything changed like new metadata release. - Check if the table which the stored procdeure is referencing. If you can post the code and table...
Here are some of things you can keep eye on apart from knowing the replication is not GA solution which is a common myth. 1> Use replication monitor...
This is not possible, please check the link below for software requirement for SQL server 2008 Enterprise 32 bit....
Are you installing SQL 2008 express edition on windows XP SP2 ? -Sat
Separate names with a comma.
