No announcements
Filter
:
All threads
All threads
Answered
Unanswered
Proposed answers
General discussion
No replies
Helpful
Has code
All languages
-
Sticky33Votes
!!! Internal MSSQL product teams, employees & MVPs blogs list !!!
Microsoft SQL Server Team Blogs List: · SQL Server Front End Team blog (SSMS, SMO, SQLAgent, Data Collector, ...24 Replies | 37859 Views | Created by Dannol Liu - MSFT - Thursday, September 04, 2008 2:43 AM | Last reply by Kumar Vivek - Thursday, March 14, 2013 12:43 PM
-
Unanswered0Votes
I am trying to shrink Data file and getting this error
k4 Replies | 65 Views | Created by '''HuuM''' - 6 hours 2 minutes ago | Last reply by Pradeep_DBA - 1 hour 25 minutes ago -
Unanswered0Votes
upgradation
Hi, Please tell me what are the prerequisites for upgradation and migration of sql server 2005 to 2008r2?2 Replies | 51 Views | Created by Surya.chamala - 5 hours 23 minutes ago | Last reply by André CR - 1 hour 39 minutes ago -
Answered0Votes
Is there a simple way to query every column of a table
I'm using SQL Server Express 2012. I had a couple of questions: 1. I would like to know if there is a simple way to query every column in a table. By simple, I mean some sort of ...4 Replies | 87 Views | Created by McBeef - Monday, August 05, 2013 10:59 PM | Last reply by drym - 1 hour 50 minutes ago -
Unanswered0Votes
i am having session time outs on this stored procedure
0 and @nSecurityLevel>=2 -- This means use the AOS Security. This includes: Classfication levels, masking, and custodians. begin declare @dCurDate datetime, ...1 Replies | 38 Views | Created by '''HuuM''' - 4 hours 56 minutes ago | Last reply by Sanil Mhatre - 2 hours 21 minutes ago -
Unanswered0Votes
SQL Server Timeout expired
i am having lot of session timout errors in my database, i have no idea where to start looking ...2 Replies | 70 Views | Created by '''HuuM''' - 4 hours 38 minutes ago | Last reply by Sanil Mhatre - 2 hours 51 minutes ago -
Unanswered0Votes
SQL Server 5 Express
The software for my diabetic meter wants me to setup or be able to connect to a SQL Sever for a data base. I am having trouble connecting to a server. This software also requires aspnet ... -
Unanswered0Votes
issue with webapp SQL Server authentication
I am setting up a connection string with password and username in a website. The user name belongs to a user role that is the DBO of the databse the web app will be using. Anyhow when I ...3 Replies | 48 Views | Created by svt44cobra66 - 7 hours 36 minutes ago | Last reply by Tom Phillips - 4 hours 18 minutes ago -
Answered0Votes
ODBC configuation from a batch file.
I am setting up a server and would like to pop a batch file on the active directory that would automate a configuration of an ODBC connection to my server! I hope others have done this before.. Maybe ...5 Replies | 57 Views | Created by UpTide - 7 hours 10 minutes ago | Last reply by UpTide - 4 hours 56 minutes ago -
Answered0Votes
Connect to a remote computer's local database
Hi Guys! I have a local sql server 2012 database at home pc. I know my home computer's ip address, the server name and the database name. I want to add this ...4 Replies | 58 Views | Created by Flashbond - 8 hours 46 minutes ago | Last reply by Flashbond - 8 hours 23 minutes ago -
Unanswered0Votes
How To Start with SQL Server LocalDB
Hello, I am currently using Access for the database of a desktop solution, and wanted to move this to SQL Server LocalDB, but can't seem to figure out how I create a LocalDB or for that matter what ...1 Replies | 40 Views | Created by MLyons10 - 9 hours 1 minutes ago | Last reply by Charles David C - 8 hours 46 minutes ago -
Answered1Votes
i need to modify this query to get the count of last 15 minutes of data
'2013-07-30 00:00:00.000' and dCreated1 Replies | 42 Views | Created by '''HuuM''' - 9 hours 18 minutes ago | Last reply by Olaf Helper - 8 hours 59 minutes ago -
Answered1Votes
Push existing table into a new Schema
I have a table named "dbo.Lease" and there is a schema that has tables that look like "ground.dj.Orders" My task is to push the ...2 Replies | 213 Views | Created by DJ Rele - Monday, July 01, 2013 1:54 PM | Last reply by DJ Rele - 10 hours 0 minutes ago -
Unanswered0Votes
Monitoring
Hi, How to monitor the logs for successful execution of all the specified jobs?3 Replies | 94 Views | Created by Surya.chamala - Monday, August 05, 2013 9:36 AM | Last reply by Alisa Tang - 12 hours 38 minutes ago -
Proposed0Votes
SQL instance doesn't accept Connections periodically
Hi everyone, I have SQL 2k5 instance. during recent days I periodically got this error: "The client was unable to reuse a session with SPID xx, which had been reset for ...3 Replies | 84 Views | Created by Oliver_Wang - Monday, August 05, 2013 9:31 AM | Last reply by Shanky_621 - 12 hours 44 minutes ago -
Proposed1Votes
Auditing
Hi, As a Sql server DBA how can we audit who deleted the rows or some data in a table or who deleted some objects?2 Replies | 50 Views | Created by Surya.chamala - 13 hours 59 minutes ago | Last reply by Geert Vanhove DCOD - 13 hours 49 minutes ago -
Proposed3Votes
Truncate
Hi, difference between truncate_only and no_truncate?8 Replies | 108 Views | Created by Surya.chamala - 17 hours 22 minutes ago | Last reply by Satheesh Variath - 14 hours 50 minutes ago -
Proposed0Votes
error 3415
Hi all: I recently download sql server 2012 I try to attach databases, but I have this error Database 'DBName' cannot be upgraded because it is ...6 Replies | 90 Views | Created by volar - Monday, August 05, 2013 6:20 PM | Last reply by Markwillium - 15 hours 42 minutes ago -
Answered0Votes
SSMS Client Installation
Hi All, I have installed sqlserver 2012 BI in my server and had only one license. When i tried to install the shared features on client machines its asking for license. Should i ...3 Replies | 79 Views | Created by venkatESH RAJAM - Monday, August 05, 2013 8:16 PM | Last reply by Katherine Xiong - 16 hours 14 minutes ago -
Answered1Votes
Installation
Hi, If standalone sql server installation fails, how do we troubleshoot? What are the causes for failure pls explain clearly with how to resolve by taking some causes?3 Replies | 57 Views | Created by Surya.chamala - 17 hours 28 minutes ago | Last reply by Shanky_621 - 16 hours 19 minutes ago -
Unanswered4Votes
DTS OR SSIS PACKAGES
What is the use of Packages for Sql server DBA4 Replies | 116 Views | Created by Surya.chamala - Sunday, August 04, 2013 8:42 PM | Last reply by Satheesh Variath - 17 hours 11 minutes ago - Items 1 to 20 of 13600 Next ›