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     
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 39
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 45
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 34
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 32
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...
sh0t2bts@hotmail.com
06-09-2009 07:49 AM
sh0t2bts@hotmail.com Go to last post
3 34
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 108
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...
JimLad
06-08-2009 01:43 PM
Sylvain Lafontaine Go to last post
8 49
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 31
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 40
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...
Paullyie
06-08-2009 07:02 AM
Paullyie Go to last post
2 36
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,...
lez
06-07-2009 05:58 PM
Jelle Go to last post
1 47
Thanks Charles, I discussed with client and am waiting for final decision, but he will probably go with the first solution of using file...
AG
06-07-2009 08:19 AM
AG Go to last post
5 56
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 46
"Dan Guzman" <guzmanda (AT) nospam-online (DOT) sbcglobal.net> wrote Thanks, Tom
tshad
06-05-2009 10:32 AM
tshad Go to last post
3 437
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 53
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 50
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...
Kristina
06-04-2009 11:50 AM
Kristina Go to last post
1 57
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...
nzrdb6@googlemail.com
06-03-2009 06:14 PM
bass_player Go to last post
3 73
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 103
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...
Tony
06-02-2009 03:19 PM
Tony Go to last post
7 93
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...
Simon
06-02-2009 06:40 AM
Simon Go to last post
2 64
Hello, Can a SQL2000 subscriber connect to a SQL2008 publisher? TIA, AbbA
Abba
06-02-2009 12:41 AM
Abba Go to last post
2 83
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...
tshad
06-01-2009 11:59 AM
tshad Go to last post
1 70
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...
tshad
05-29-2009 05:06 PM
tshad Go to last post
6 113
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...
GMC -LSND
05-29-2009 02:25 PM
bass_player Go to last post
6 84
The classic way... :-) -- Tibor Karaszi, SQL Server...
Tibor Karaszi
05-29-2009 01:31 PM
Tibor Karaszi Go to last post
3 53
Thanks Dan. I won't be doing that again in a hurry. Charles "Dan Guzman" <guzmanda (AT) nospam-online (DOT) sbcglobal.net> wrote
Charles
05-29-2009 06:48 AM
Charles Go to last post
6 61
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 94
"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 69
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...
mastiff
05-27-2009 01:20 PM
Aaron Bertrand [SQL Server MVP] Go to last post
6 623
"Aaron Bertrand " <ten.xoc (AT) dnartreb (DOT) noraa> wrote Thanks for the help, Tom
tshad
05-27-2009 01:07 PM
Aaron Bertrand [SQL Server MVP] Go to last post
32 297
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 75
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%...
Toni
05-26-2009 03:57 PM
Toni Go to last post
1 104
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...
Schmeg
05-26-2009 03:35 PM
John Bell Go to last post
1 91
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 49
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....
Kevin3NF
05-26-2009 01:35 PM
Tibor Karaszi Go to last post
1 50
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...
Robin9876
05-26-2009 10:17 AM
Tibor Karaszi Go to last post
1 85
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 115
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...
Bishop
05-25-2009 04:12 PM
John Bell Go to last post
2 99
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...
tshad
05-25-2009 03:52 PM
Aaron Bertrand [SQL Server MVP] Go to last post
2 81
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...
Futurist
05-25-2009 03:42 PM
John Bell Go to last post
1 103
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...
tshad
05-25-2009 02:36 PM
tshad Go to last post
6 68
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...
Irina
05-22-2009 11:54 PM
Tibor Karaszi Go to last post
1 107
How does on search a transaction log for a deleted item? Thank you very much.
BrianMultiLanguage
05-22-2009 11:52 PM
Tibor Karaszi Go to last post
1 72
Is there a commpression tool (even third party tool) that knows to compress blobs?
Gal
05-22-2009 07:47 PM
Geoff Schaller Go to last post
19 190
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...
allanc
05-22-2009 07:40 PM
Geoff Schaller Go to last post
5 120
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...
tshad
05-22-2009 06:53 PM
tshad Go to last post
2 87
I am digging into some stored procedure duration issues and in looking at sys. dm_exec_procedure_stats I was wondering if it would be safe to say...
cbrichards via SQLMonster.com
05-22-2009 06:29 PM
Tom Cooper Go to last post
3 70
I should preface this with the disclaimer: I don't know anything about SQL server, so please use small words :) This is on a Windows Server 2003 R2...
twd
05-22-2009 03:34 PM
twd Go to last post
2 100
Hi, I have received a mandate to "document" my databases. It seems that there are several products out there that will scan the meta data of a...
Daniel Jameson
05-22-2009 01:18 PM
RJ Go to last post
1 61
Post New Thread

Display Options
Showing threads 2501 to 2550 of 48667
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 - 2014, Jelsoft Enterprises Ltd.