Sponsored Links

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

Page 1 of 1156

Threads in Forum : microsoft.public.sqlserver.server

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
SQL server memory usage I have a server where sqlserver.exe is using 13.5GB of 16GB of the available memory available on the server. I want to limit this to 8GB of RAM that... markcmh60	Yesterday 01:54 AM Jeroen Mostert	2	8
solutions books solutions book team solutionsbookteam(at)hotmail(dot)com We're a team for providing solution manuals to help students in their study. We sell the... solutions book team	02-01-2012 07:03 PM solutions book team	0	12
SQL Server Error 5520 I am getting the SQL Server Error 5520 when i try to add a FILSTREAM file into a filegroup. I am trying to add multiple files to a FILESTREAM... sathish B R	01-31-2012 04:57 PM Erland Sommarskog	1	6
Adding 1 Month to Date Calculation Column Hi I'm trying create a calculated column to add 1 month to a date from another column. CREATE TABLE .( NOT NULL, AS (+ ???) ) ON Cory Jones	01-27-2012 02:25 AM Jeroen Mostert	1	3
Big Bertha Thing tidings Big Bertha Thing tidings Cosmic Ray Series Possible Real World System Constructs http://www.bigberthathing.com/tidings.html Access page for 4K Web... Tony Lance	01-22-2012 02:51 PM Tony Lance	0	3
Knowledge base software benefits Provide instant content that benefits your customers and reduce the load on your customer support team. You also get free user generated content.... michael moody	01-20-2012 05:55 AM michael moody	0	4
SQL Query Multiple Rows with column distinct on first 2 characters I have a query where I need to return rows but only if one columns first two characters are unique. I have this currently which works, but want to... Andrew Beller	01-12-2012 05:35 PM Erland Sommarskog	3	4
reorder numbers in asc order then update Hello all I'm having a problem reordering my id_order column sample table ID ID_ORDER 1 1 1 3 1 4 2 1 Business Minded Men	01-03-2012 03:44 PM Erland Sommarskog	3	4
updating a numeric field-accumulating value Hello; We are new to SQL Server. Using 2008 R2. Creating a stored proc.. It contains a curser that is a select statement--selects one distinct field... TonyE	12-29-2011 05:33 PM Erland Sommarskog	1	2
restoring to a mirrored database ( 1 2 3 4 ) When I tried to run the command alter database Press_Ganey_Associates_MSCRM set single_user with rollback after 30 on a mirrored database, I got the... JOH	12-21-2011 06:42 PM Eusebio Suazo	37	44
ODBC Connection using Specific TCP Port HI, I am having issue with configuring ODBC connection to SQL server 2008 if I configure to not use dynamic port and specify port 1433 then I am not... Dush's	12-21-2011 01:54 AM Dush's	1	4
Horrible query performance - no obvious reason Hi, SQL Server 2008 R2 1 million row table PK field_id (int) IX nonclustered scheme_id (int), is_calc (bit). Not a covering index. I have run DBCC... JimLad	12-06-2011 05:53 PM Erland Sommarskog	7	8
Summarize the values of records Hi NG, I'm trying to solve the following challange, but I have a black out. I have a table like following: No Event Money Org 1 1 ... schaf	11-23-2011 10:32 AM luxverita	1	2
Linked server question. ( 1 2 ) I am not sure where to put this, so I just chose two newsgroups with hopes it fits. My problem is this: I have about 10 SQL2000 servers. I have... Geoff	11-22-2011 06:16 AM Erland Sommarskog	15	16
Big Bertha Thing balloon Big Bertha Thing balloon Cosmic Ray Series Possible Real World System Constructs http://www.bigberthathing.com/balloon.html 7K Web Page Astrophysics... Tony Lance	11-21-2011 05:07 PM Tony Lance	0	3
IP1, IP2...IPALL What are these IP addresses in the properties of TCP/IP in configuration Manager of SQL Server 2005 Standard? How do I know what to type here? The... sql464	11-18-2011 06:15 AM Erland Sommarskog	3	4
Linked server question. I am not sure where to put this, so I just chose two newsgroups with hopes it fits. My problem is this: I have about 10 SQL2000 servers. I have... Geoff	11-15-2011 04:24 PM Geoff	0	3
Copy a table in SQL Server 2005 ( 1 2 3 4 5 ... Last Page) Hello all I want to make a copy of a table in SQL Server 2005, a back-up of my table if you will. I don't see any way of doing this, I am I right... David	11-09-2011 07:29 PM Aaron Kempf	93	94
Big Bertha Thing retrenchment Big Bertha Thing retrenchment Cosmic Ray Series Possible Real World System Constructs http://www.bigberthathing.com/retrench.html Access page to 600K... Tony Lance	10-23-2011 11:03 AM Tony Lance	0	3
who changed my table ? ....is there an easy way to see this in the database or do I need to set up some kind of auditing mechanism ? Dog is love	10-20-2011 05:21 PM Erland Sommarskog	3	4
numeric wildcards asp.net web application, using sqldatasource for a gridview datasource, eight dropdownlists used as sources for @variables in the sqldatasource... Sue	10-14-2011 05:43 PM Stu Alderman	6	39
Increased row size decreasing I/O throughput Here's a little puzzler. If anyone's encountered a similar issue or knows what I'm doing wrong I'd love to hear it. SQL Server 2008 R2. I've got a... Jeroen Mostert	10-02-2011 01:57 PM Jeroen Mostert	6	7
Could not continue scan with NOLOCK due to data movement. I received the error message Could not continue scan with NOLOCK due to data movement. when I run the following SQL update statistics PCR_Value with... Ching-ju Lee	09-28-2011 03:13 AM Erland Sommarskog	6	37
BLOB storage options I will be creating a web application where upload and modification of documents will be an important part of the application. Specifically, users... Bill E. Hollywood, FL	09-27-2011 06:01 PM Bill E. Hollywood, FL	4	5
Looking for a little longer-term (offline) help than a couple of newsgroup replies (posted in one other forum - won't do anymore) Before I even get started, let me apologize for the length of this post. In two sentences - I'm asking if someone wants to give some (free) counsel... Kurt Dicus	09-22-2011 05:57 PM Erland Sommarskog	5	6
Big Bertha Thing Faculty Big Bertha Thing Faculty (Sequel to battle) Cosmic Ray Series Possible Real World System Constructs http://www.bigberthathing.com/faculty.html Access... Tony Lance	09-20-2011 01:49 PM Tony Lance	0	3
STANDBY mode ( 1 2 ) Hi how to put the database to standby mode for log shipping: *** Error: The restore operation cannot proceed because the secondary database...	09-18-2011 06:35 AM Erland Sommarskog	17	247
Linked Server Error I am running SQL Server 2008 on a Win 2k3 server. We have a linked server that connects to a UniData DB. This was setup in December 2008 and... Michael Barrett	09-16-2011 06:24 AM A Harms	4	47
Suitable O/S Hello I am running the mdse version of SQL for our main business application. we are a small business with 15 users, and because of cost and... Paddy	09-16-2011 02:43 AM Paddy	5	6
Tempdb autogrow set to 1MB Let's say I go in and set the autogrow for the tempdb and templog to 100MB (for example). What could cause it to reset itself to autogrow by 1 MB? ... =?Utf-8?B?amFzb243NjU1?=	09-14-2011 01:08 AM Maurice De Vidts	2	21
Unable to start agent ( 1 2 3 4 ) I am having an issue where I cannot start the sql agent service using a domain user account. When using SQL configuration manager to change the... Jason Blair	09-12-2011 10:12 AM ejac	30	37
SQL 2005 and Pervasive Linked Server We are migrating from SQL 2000 to SQL 2005. One of the requirements we have is to link to a Pervasive DB. We did this successfully under SQL 2000... Steve Z	09-12-2011 06:47 AM Sacky	7	42
User permission being removed when i restore database on another server. Hi All, I have 2 sql servers 2008. Every night we backup the database on server A and then load it on server B as an archive. The problem is on... woohoo30@hotmail.com	09-10-2011 06:46 PM woohoo30@hotmail.com	1	2
select data from linked server I have sqlserver 2008, called 'Server A'. It has a linked server setup. How do I select from table in the linked server from 'Server A'. I can so... Phil Hunt	09-06-2011 11:26 AM Phil Hunt	5	6
SQL2008 shared hosing login permission Hello, for my mssql shared hosing I have create a database and login using security settings write by microsoft for sql shared... Antony	09-03-2011 05:22 AM Antony	0	2
Re: SQl complex Stored Procedure using cursors Please be polite enough to post DDL, as required by Netiquette. You also missed a basic term and do not follow ISO-11179 naming rules for data... --CELKO--	09-01-2011 07:39 PM --CELKO--	0	3
add the drop database command in the SQL server log file Hi, I am trying to add to the default SQL server log file (in the section /Management/SQL Server Logs from Management Studio) the command... Grille12	08-24-2011 05:51 PM Erland Sommarskog	1	2
Big Bertha Thing Battle Big Bertha Thing Battle Cosmic Ray Series Possible Real World System Constructs http://www.bigberthathing.com/battle.html Access page to 600K ZIP... Tony Lance	08-20-2011 04:13 PM Tony Lance	0	2
Linked server sql2k8 x64 -> sql7 Is there anyway to get this to work? This is what I get: OLE DB provider "SQLNCLI10" for linked server "P100S005" returned message "Client unable to... Peter Lindberg	08-19-2011 10:19 AM Xavier Sanchez	3	164
check unique constraint just with the commit statement??? Hi NG, I have a little problem. In a DB table a have an attribute which just contains an number which must be unique. Therefore I added a... schaf	08-16-2011 02:31 PM Erland Sommarskog	1	2
SQL 2008 Auditing I have a database with lots of tables accessed using Windows Authentication.. I need to audit all actions on all tables by all users in this db. I... Allen Jones	08-05-2011 09:26 AM Allen Jones	0	2
How to get a two-digit month value ( 1 2 3 4 5 ... Last Page) Howdy. I'm attempting to use DATEPART to give me a two-digit month, and further, to cast that as a nvarchar. It is rendering March as '3' instead of... Danny	08-04-2011 09:47 AM Alexander Matos	68	69
Default FILESTREAM filegroup is not available in database ( 1 2 ) Hello, I am creating a table on a SQL 2008 database as follows: create table Slides ( ID uniqueidentifier not null constraint PK_Slide primary key... shapper	07-28-2011 09:39 AM blackjack	12	28
How to round down decimal like 15.9 to 15? Hello, I have this: declare @myvar as decimal set @myvar=15.84 select cast(@myvar as int) Result: 16 I want to always round down. How can I get a... Andreas Klemt	07-20-2011 09:46 AM Jon Ford	5	40
How to open standby database for read/write? Hello! I have log shipping setup between primary sql server and standby server. Both servers are MSSQL 2005 Enterprise. What are the steps to open... Lena	07-19-2011 05:13 PM Erland Sommarskog	1	2
Can somebody explain this strange sql statement It's a webbsite using C# and ado.net to access a oracle database. Below is just the beginning of the sql select statement that is used and here... Tony Johansson	07-18-2011 05:23 PM Erland Sommarskog	2	3
The Business Intelligence Conference 2011 is back! (July 30, Blore)] Hi , I got to know of an exciting event happening in Bangalore on July 30th. I guess it will add a great value to all the Business... sha t	07-16-2011 02:17 AM sha t	0	2
Run same query on multiple databases. ( 1 2 ) I have about 230 databases on my sql server. Out of which 220 or so are Dynamics Databases on which I want to run the same standard query as below. ... Sammy	07-12-2011 02:42 PM David Yard	14	232
x64 SQL Server2008 R2 on Windows Server 2008 R2 - Max Memory usagevalue not honoured? Hi, I have been told by someone who ought to know that setting Max Memory on a SQL server instance through the Properties-->Memory tab in SSMS has... JimLad	07-05-2011 04:22 AM Erland Sommarskog	4	5
Setting Column Description Property with a query Using SQL Server 2005 & SSMS. Hello all, I have 2 tables that I want to set the "Description" property for each column with a query. I have 2... CTB	06-28-2011 03:20 PM Erland Sommarskog	1	4

Page 1 of 1156

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off