No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Unanswered0Votes
sqlservr 1804 error api.log
SQL Server 2012 Stantdard / Windows Server 2012 Datacenter Wndows event viewer shows there are many "sqlservr 1804" error. Windows server always crashed due to this error. ...6 Replies | 173 Views | CrossRay - Thursday, June 20, 2013 6:33 AM | Last Reply Sethu Srinivasan - 12 hours 52 minutes ago -
Unanswered1Votes
Help on blocking within tempdb
On one of our 2008 R2 SP2 sql server we are experiencing blocking in tempdb. The blocked requests are Intellisense and Data Collection queries. We have found some stored procedures that ...4 Replies | 112 Views | Bpie7 - Tuesday, July 02, 2013 3:45 PM | Last Reply Shanky_621 - 19 hours 27 minutes ago -
Proposed0Votes
A trigger to make a log to check which logins has been modified
I am creating a trigger to make a log to check which logins has been modified. I have written the code as below. Can any one say what will be in ???. i.e which login ...1 Replies | 54 Views | Raja Bhadra - Friday, July 05, 2013 7:33 PM | Last Reply Duane Dicks - Friday, July 05, 2013 7:59 PM -
Proposed0Votes
How to get the status of the SQL Server replication service
How to get the status of the SQL Server replication service by T-SQL statement? Christopher1 Replies | 47 Views | Christopher3683 - Friday, July 05, 2013 10:53 AM | Last Reply Srinivasan Ram - Friday, July 05, 2013 12:09 PM -
Unanswered0Votes
How to check the Error Log size
Hi, How to check the error log size for all the Database in the particular instances Christopher4 Replies | 67 Views | Christopher3683 - Friday, July 05, 2013 4:38 AM | Last Reply Shanky_621 - Friday, July 05, 2013 6:13 AM -
Unanswered1Votes
Over 8GB TEMPDB required to DBCC CHECKDB of size 2.5GB!
This is for a SCOM 2012 SP1 OperationsManager database running on a dedicated DB server with SQL Server 2012 SP1. When I run a DBCC CHECKDB('OperationsManager') I get the following ...3 Replies | 88 Views | Beneque - Tuesday, July 02, 2013 4:20 PM | Last Reply Srinivasan Ram - Friday, July 05, 2013 3:56 AM -
Unanswered0Votes
MS VS 2012 Dtabase Project and CDC
Hello I have some table under CDC. And I have a stored procedure that use CDC table (for example [cdc].[directory_Cards_CT]). And when I add this SP in database project, I get ...0 Replies | 51 Views | Rogatnev - Thursday, July 04, 2013 8:49 AM -
Answered3Votes
Automated Backup SQL SERVER 2008
Hi. I have installed sql server 2008 enterprise edition. I need to get automatic backups, one per day, and with diferent names (correlative or identified by ...6 Replies | 14409 Views | teo_fool - Wednesday, July 13, 2011 11:45 PM | Last Reply pringgo.setiko - Thursday, July 04, 2013 8:20 AM -
Unanswered0Votes
Importing data from Exported Table information (without using Bulk Insert)
Hey guys, I am looking for some information, or some thoughts on how I can accomplish the following... I have a document (.txt) that I have ...1 Replies | 66 Views | Rokitec - Wednesday, July 03, 2013 8:11 PM | Last Reply Shanky_621 - Thursday, July 04, 2013 5:51 AM -
Unanswered0Votes
Looking for SQL Server third party tools
Im looking for tools in sqlserver where you can configure some rules and it will prompt user for satisfying the same. For example while writing dynamic queries and if we forget to add comma between ...2 Replies | 115 Views | Cool_Guru - Tuesday, June 25, 2013 9:56 AM | Last Reply scott_morris-ga - Wednesday, July 03, 2013 3:35 PM -
Unanswered0Votes
NUMA Concepts and understanding
I am just wondering whether anyone can help me understanding the NUMA on Vmware platform. I have executed the below statement on vmware machine which ...2 Replies | 79 Views | kccrga - Wednesday, July 03, 2013 6:47 AM | Last Reply Shanky_621 - Wednesday, July 03, 2013 9:03 AM -
Answered0Votes
Microsoft Press - Practice Test 70-462
Hello, I have just taken the practice test that came with the 70-462 Administering SQL Server 2012 databases training kit. One question (ID 462P4.2_01) asks about ...5 Replies | 654 Views | Andrew Pruski - Tuesday, May 07, 2013 2:43 PM | Last Reply Andrew Pruski - Sunday, June 30, 2013 11:35 AM -
Answered0Votes
List of 3rd Party SQLServer 2008/R2 Tools
Is there a comprehensive list of 3rd party sqlserver tools some where that I can refer to? I have been tasked with finding a list of tools that we DBAs can use to better administer, manage and ...4 Replies | 9358 Views | grajee - Thursday, July 28, 2011 2:22 PM | Last Reply William-Johnson - Friday, June 28, 2013 9:14 AM -
Answered0Votes
Invalid Class Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases
I have been trying to resolve an issue with WMI counters for SQL Server 2005. The Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases class is not in the WMI tables. I am running SQL ...2 Replies | 2442 Views | Hank Leander - Thursday, September 06, 2012 3:45 AM | Last Reply Andreas.eriksson7 - Friday, June 28, 2013 4:26 AM -
Answered0Votes
Send using cdo
Hi, I inherited code that needs to work with my SBS 2008 Exchange 2007 server. This is the original code: <!--#include ...1 Replies | 104 Views | Mertoman - Thursday, June 27, 2013 3:59 PM | Last Reply Shanky_621 - Thursday, June 27, 2013 5:26 PM -
Unanswered0Votes
Alerts in SQL SERVER 2000
Severity alerts from 19-25 and data and log file size alerts are not working on SQL SERVER 2000 SP3 Stnd Edn, any idea to fix this?0 Replies | 102 Views | mukki123 - Thursday, June 27, 2013 3:03 PM -
Discussion0Votes
SQL SERVER CLUSTER
Need steps to test failover and failback only SQL instance in WINDOWS 2003 CLUSTER server having MSSQL 2005 edn ASAP.1 Replies | 110 Views | mukki123 - Thursday, June 27, 2013 2:35 PM | Last Reply mukki123 - Thursday, June 27, 2013 2:55 PM -
Unanswered0Votes
SQL Server 2008 Management Studio - Edit top 200 Rows
New Install of 2008 Server with Management Studio. When I right click a table and select Edit top 200 Rows, I get theis error: "Invalid prefix or suffix characters. (MS Visual Database ...1 Replies | 134 Views | Netwisedev - Wednesday, June 19, 2013 10:18 PM | Last Reply Fanny Liu - Thursday, June 27, 2013 10:19 AM -
Answered0Votes
Installing SSMS 2008 - need SSIS and job management etc.
I have the Developers edition of SQL Server 2012. There is an instance of SQL Server 2008 that I need to work with, however. I can't create SSIS packages for this humble version of SQL Server using ...1 Replies | 103 Views | drexasaurus - Monday, June 24, 2013 6:47 PM | Last Reply Samuel Lester - MSFT - Wednesday, June 26, 2013 12:26 PM -
Answered0Votes
SQL SERVER 2005 Cluster
Hi Need all steps to change windows authentication mode to mixed mode in WINDOWS 2008 R2 CLUSTER server having MSSQL 2005 edn ...10 Replies | 140 Views | mukki123 - Tuesday, June 25, 2013 4:50 PM | Last Reply Tom Phillips - Tuesday, June 25, 2013 5:55 PM - Items 1 to 20 of 907 Next ›