dbTalk Databases Forums  

Sponsored Links

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

Discuss in the microsoft.public.sqlserver.server forum.

Post New Thread
Threads in Forum : microsoft.public.sqlserver.server Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Hello, Iam in the process of deciding the hardware for our new SQL2008 box. For the same, I need to include the socket information in the existing...
06-09-2009 10:49 PM
Abba Go to last post
4 50
Hello, Iam in the process of upgrading our SQL2000 to SQL2008 and investigating if I need to upgrade the hardware as well. To find that, I need to...
06-09-2009 10:48 PM
Abba Go to last post
2 58
For the life of me I can't figure out why I have this error. here is my Stored Procedure. USE GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO
Mike Coleman
06-09-2009 09:06 PM
Mike Coleman Go to last post
3 45
I am curious about the scheduling of the maintenance plans. Do the Optimizations, Integrity, Complete Backup, & Transaction Log Backup need to be...
Saucer Man
06-09-2009 01:57 PM
Saucer Man Go to last post
6 46
I have backup database task and I set that backup set will expire after 14 days. Than I have History cleanup task to remove historical data older...
Simon Z
06-09-2009 11:03 AM
Tibor Karaszi Go to last post
3 57
What tool are you using when you get teh timeout? Have you tried increasing the timeout...
Muhammad Bilal
06-09-2009 09:59 AM
Tom Moreau Go to last post
7 50
Good Day, MANY years ago it was almost mandated by the MSSQL gurus that an MSSQL instance/data should NOT be on the same PHYSICAL hard drive as the...
Carl Hilton
06-09-2009 09:49 AM
TheSQLGuru Go to last post
7 41
Hi All, I'm using SQL 2005 Standard Edition and I have some Indexes that are fragmented but won't de-frag to 0% when re-build, I have...
06-09-2009 07:49 AM
sh0t2bts@hotmail.com Go to last post
3 50
The problem is there is no meaningful information to tell you which row is which. And if the three rows are the same (5585 + John) then...
Muhammad Bilal
06-08-2009 02:24 PM
Muhammad Bilal Go to last post
20 141
For more info on the date format, see the thread "SQL Server and Dates" on June 06, 2009 in the newsgroup m.p.sqlserver.programming. -- Sylvain...
06-08-2009 01:43 PM
Sylvain Lafontaine Go to last post
8 64
I installed SQL2008 for testing and now I want to remove it but I see nothing in "Add/Remove Programs" for removing it. Also, nothing in the program...
Richard Lawson
06-08-2009 12:08 PM
Richard Lawson Go to last post
3 39
For different insert statements, you can timestamp the inserts. But if you are talking aout the rows inserted by the smae statement, there is...
Linchi Shea
06-08-2009 09:14 AM
Uri Dimant Go to last post
2 45
Hi Guys n' Gals, As the title says, How do I go about installing a SQL 2000 Instance on an a server where SQL 2005 Server already installed. I have...
06-08-2009 07:02 AM
Paullyie Go to last post
2 51
Hi Guys, I have been using some code behind my 'not in list' for a combo box in my Access 2007 database. It worked fine when linked to ACCESS BE,...
06-07-2009 05:58 PM
Jelle Go to last post
1 61
Thanks Charles, I discussed with client and am waiting for final decision, but he will probably go with the first solution of using file...
06-07-2009 08:19 AM
AG Go to last post
5 66
Hello. In the experiment, I stop SQL Server 2005 and delete the data files of the database. After restart SQL Server 2005, the database can be...
Tao Lei
06-05-2009 11:40 PM
Tao Lei Go to last post
2 65
"Dan Guzman" <guzmanda (AT) nospam-online (DOT) sbcglobal.net> wrote Thanks, Tom
06-05-2009 10:32 AM
tshad Go to last post
3 487
On Thu, 04 Jun 2009 15:50:34 GMT, "stuarta" <u52371@uwe> wrote: .... Hmm, I wonder why not Express? It's true that Express is limited in several...
David Hay
06-04-2009 07:15 PM
Armen Stein Go to last post
1 64
Using sql 2005 + visual studio (local) I working (remote) as a "user" on a sql 2000 database. I am the owner of the database, but I not an...
Albert D. Kallal
06-04-2009 03:32 PM
Albert D. Kallal Go to last post
4 57
On Jun 4, 11:46*am, "TheSQLGuru" <kgbo... (AT) earthlink (DOT) net> wrote: Thanks Kevin, This further verfies what I have been thinking. We will be...
06-04-2009 11:50 AM
Kristina Go to last post
1 70
I have 2 SQL Server 2000 instances - PROD and DEV. I have been trying to restore a backup of db from PROD to create a new db on DEV. I get this err...
06-03-2009 06:14 PM
bass_player Go to last post
3 106
If it was a generic SQL Server backup, it should work. COuld be the file came off the tape corrupted.... -- Kevin3NF SQL Server dude You want...
Willie Bodger
06-03-2009 02:49 PM
Kevin3NF Go to last post
8 125
Hi Linchi, I agree that a flat file is a good way to go but I'm using MS Access to create charts based on the information so it's easier for me to...
06-02-2009 03:19 PM
Tony Go to last post
7 100
Hi Uri, We didn't call MS because the client didn't want to. I think because they felt that all MS could do is run the DBCC CHECKDB tool - which...
06-02-2009 06:40 AM
Simon Go to last post
2 76
Hello, Can a SQL2000 subscriber connect to a SQL2008 publisher? TIA, AbbA
06-02-2009 12:41 AM
Abba Go to last post
2 90
That worked for my console and telnet (was either 1422 or 3529) as my log showed: Server is listening on and Server is listening on But I tried...
06-01-2009 11:59 AM
tshad Go to last post
1 89
I am moving a bunch of data from tables in one database to another. I disabling all my constraints to do this. I would normally not do this but I...
05-29-2009 05:06 PM
tshad Go to last post
6 130
SQL 2008 Just started using the above database and after a week, no one could get into the database. A quick call to the creater of the software...
05-29-2009 02:25 PM
bass_player Go to last post
6 100
The classic way... :-) -- Tibor Karaszi, SQL Server...
Tibor Karaszi
05-29-2009 01:31 PM
Tibor Karaszi Go to last post
3 60
Thanks Dan. I won't be doing that again in a hurry. Charles "Dan Guzman" <guzmanda (AT) nospam-online (DOT) sbcglobal.net> wrote
05-29-2009 06:48 AM
Charles Go to last post
6 71
So do you have the same issues immediately after a re-build or do they start a while after? Have you looked at profiler to see what is erroring and...
John Bell
05-29-2009 04:11 AM
John Bell Go to last post
3 102
"deVoijs" <deVoijs (AT) discussions (DOT) microsoft.com> wrote John
John Bell
05-28-2009 10:48 AM
Günter Prossliner Go to last post
1 83
I have 2 web server in load balancing configuration (NLB) and one database. We are going to add another web server. The problem is simple: too many...
05-27-2009 01:20 PM
Aaron Bertrand [SQL Server MVP] Go to last post
6 641
"Aaron Bertrand " <ten.xoc (AT) dnartreb (DOT) noraa> wrote Thanks for the help, Tom
05-27-2009 01:07 PM
Aaron Bertrand [SQL Server MVP] Go to last post
32 320
Hey all - I've been googling around trying to find some code that will process a tsql query string (with *=, =*, = joins) into ansi sql using the ...
my name
05-27-2009 10:01 AM
Sylvain Lafontaine Go to last post
4 83
I've got a sql 2005 build 3282 cluster with 4 – 3.4Ghz Dual Core Processors with 20gb RAM (15gb allocated to sql) that has been running at 90-100%...
05-26-2009 03:57 PM
Toni Go to last post
1 112
I'm not sure which is the most appropriate group for this question. I have an application that - on a daily basis - appends information into 20-30...
05-26-2009 03:35 PM
John Bell Go to last post
1 112
The only I can think of is sys.master_files. Read the documentation for this before you use it, since the doc should reflect how up-to-date this...
Tibor Karaszi
05-26-2009 02:01 PM
Tibor Karaszi Go to last post
2 63
Your original query is an INSERT with a subSELECT. I.e., it takes the rows returned from the SELECT statement an inserts them into the RECFILE table....
05-26-2009 01:35 PM
Tibor Karaszi Go to last post
1 60
On a SQL 2000 server the following warning is occurring at 4am when there are no jobs for at this time and there are likely to be any users logged...
05-26-2009 10:17 AM
Tibor Karaszi Go to last post
1 101
All, I am running Windows Server 2003 x64 with SQL 2005 64 with 8 gigs of ram. My system is running extremely slow. The system is paging very hard...
Noah Hamilton
05-26-2009 06:04 AM
Toni Go to last post
5 128
SQL 2000 When I'm on the console of the server I am able to connect to the database using Enterprise Manager when I setup a connection using...
05-25-2009 04:12 PM
John Bell Go to last post
2 113
Hmm, never used Vista all that much except in a virtual machine. In which case I never needed to find the shutdown button, because I can manage...
05-25-2009 03:52 PM
Aaron Bertrand [SQL Server MVP] Go to last post
2 92
While trying to connect to Local or Remote Server on the network I received the following error, what could be happening? I need help... It's a SQL...
05-25-2009 03:42 PM
John Bell Go to last post
1 127
On 2008, we have some legacy data that we have in a separate database. We need to move about 10 tables from the legacy database to our Dev and...
05-25-2009 02:36 PM
tshad Go to last post
6 78
I have Access front end and SQL back end database. I am trying to synch 2 tables together, insert records from table1 into table2 if they do not...
05-22-2009 11:54 PM
Tibor Karaszi Go to last post
1 120
How does on search a transaction log for a deleted item? Thank you very much.
05-22-2009 11:52 PM
Tibor Karaszi Go to last post
1 83
Is there a commpression tool (even third party tool) that knows to compress blobs?
05-22-2009 07:47 PM
Geoff Schaller Go to last post
19 210
Can someone please advise which options I have to select in the SQL 2005 Collation Sequence tab to choose the 'SQL_Latin1_General_CP850_Bin'? Thanks...
05-22-2009 07:40 PM
Geoff Schaller Go to last post
5 139
On 2008, I am finding these in my Sql Logs (about 6000 of them) done in about 30 seconds. This seems to happen 6 or 7 times a day. 05/22/2009...
05-22-2009 06:53 PM
tshad Go to last post
2 101
Post New Thread

Display Options
Showing threads 2501 to 2550 of 48668
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.