Hi, I 've just installed SS 2008 Developer Edition in my machine. It is running side by side with a SS 2005 Developer Edition. After installed (the...

Adrian Garcia

08-29-2008 12:18 PM
chintan mehta

I'm using SQL Server 2008 and I'm writing Queries in SMSS. I find that if I add a new object (e.g. a new Table) to the database, the intellisense...

Ed White

08-28-2008 10:51 PM
Mark Han[MSFT]

Help, in SSMS 2005 I get the following error when I try to view the securables on the Database Role Propery dialog. If I click the Add button and on...

JM

08-27-2008 12:02 PM
JM

I have an LCS2005 standard server where the rtc.ldf is 3.5GB and the rtc.mdf is 300MBs. I need to free up some space on the server so I want to...

08-26-2008 03:32 PM
Ekrem Önsoy

All, I have two Vista SP1 machines that have SSMS 2005 installed on them. These two machines (both used by developers) cannot see my new named SQL...

Ant-nee

08-20-2008 09:46 AM
Ant-nee

Any one konw the step how to restore sql 2000 database to sql 2005 i got error when i restore backup.bak(backup from sql 2000) file to sql 2005 i...

Ken

08-17-2008 02:18 AM
ponnarasu jayadevan

I have seen that several times with SSMS 2005 (and similar apps with heavy UIs). Always fixed by a video driver update (this particular type...

Aaron Bertrand [SQL Server MVP]

08-14-2008 06:17 PM
Erland Sommarskog

Hi, This is my first post. I backed up my registered servers on SSMS 2008, including passwords, re-installed my OS from scratch, and imported the...

Eddy

08-14-2008 10:39 AM
Eddy

Hi People, what tool/how do I generate database diagrams/schematics for a sql 2000 db? I need to see tables, relationships etc. I only have...

NJS

08-13-2008 02:25 PM
NJS

Are you looking for a Job in India??? You have experience in Java, Oracle, .NET, SQL Server, SAP and testing tools. Than you can wait a minute and...

Naveen

08-12-2008 03:20 PM
Naveen

I am developing a SSIS package using BIDS. I have many variable that are scope to the Package level. When I set breakpoints and go to the...

fschmid

08-11-2008 05:00 PM
fschmid

Here's what my data looks like: "12312331 ","DOE, JOHN","3423423",0,1900-01-01 00:00:00,"","@@ ","","JOHN DOE PROCESSING PLANT" Here's my...

Brad

08-11-2008 12:22 PM
Linchi Shea

Hi, I'm trying to import a file from excell that uses thai characters and english into sql server 2000. i'm using the import export tool, and...

Dean g

08-11-2008 07:33 AM
Dean g

---------- Forwarded message ---------- From: mike.mcn... (AT) gmail (DOT) com Date: Jul 30, 3:47 pm Subject: automated uninstall of sql server 2000...

mike.mcneer@gmail.com

08-05-2008 03:53 PM
mike.mcneer@gmail.com

Any time we try to create a backup of a database using any method, including the backup option on the All Tasks menu, the backup never starts but...

Charles Allen

08-04-2008 11:10 PM
Aaron Bertrand [SQL Server MVP]

I am looking for any tools capeable of repairing or recover data from a corrupt (LDF) log file. I have a situation where my mdf and ldf files...

John

08-03-2008 09:40 PM
Aaron Bertrand [SQL Server MVP]

I am looking for any tools capeable of repairing or recover data from a corrupt (LDF) log file. I have a situation where my mdf and ldf files...

John

08-03-2008 09:30 PM
John

Hi All, Certification in Mind??? Visit www.itjobguru.com for Latest Material. Regards, Naveen

Naveen

08-03-2008 02:48 PM
Naveen

Hi, I have been beating my head against the wall on this one, and am hoping someone can point out what I am doing wrong here. I am trying to set up...

Anand

07-31-2008 06:07 PM
Erland Sommarskog

I'm Running SQL 2005 and Microsoft SQL Server Management Studio (9.00.3042.00) and experiencing strange behaviour when results from my queries are...

stefan.jansen@hagstofa.is

07-31-2008 03:56 AM
bass_player

When running profiler I am seeing strange duration times on some of the processes. I have seen large numbers before on a logout, but this is on...

jim.steiner@rackspace.com

07-30-2008 10:32 AM
Anand

Good Afternoon, I have run the SQL Server Profiler to assist me in optimizing the perfomance of one of my databases. The Profilier was started and...

Joe

07-29-2008 03:48 PM
Joe

Run Microsoft SQL Server 2000 Express Edition on OS server 2000 Standard. Works fine; can't recall how I set it up. Now newly installed Microsoft...

Monde

07-26-2008 07:01 AM
Ekrem Önsoy

We have an sql 2000 sp4 server that locks up whenever we try to run a maintenance plan with only the option to Reorganize data and index pages option...

TMurnion

07-24-2008 04:30 PM
TMurnion

I have Management Studio installed on two different machines, one is 9.00.3042.00 (SP2) running against SQL Standard Edition SP2 and the other is...

Michael MacGregor

07-24-2008 02:52 AM
Tibor Karaszi

I have generated a trace by using SQL Profiler (SQL Server 2005). I have launched the profiler in a test environment connecting to a...

Pasquale

07-23-2008 09:33 AM
Pasquale

Part of the problem I think (maybe not in this specific thread, but in general) is that people correlate "truncate" and "shrink". So it's important...

Chris

07-22-2008 05:45 PM
Erland Sommarskog

(Cross-posting from general SQL newsgroup) I 2nd vler's request to understand better what the definitions for all of the values of the "Mode"...

Hydrogen76

07-21-2008 09:28 AM
Hydrogen76

Dear ladies and gentlemen, Upscene Productions is happy to announce the next version of their test data generator tool: "Advanced Data Generator 2"...

Martijn Tonies

07-21-2008 03:44 AM
Martijn Tonies

Enterprise Manager will not return rows from tables in the database. Returns either a blank screen, or ms design tools catastrophic error depending...

JIMF

07-18-2008 02:07 PM
Roy Harvey (SQL Server MVP)

Hi at all! I need a tool to migrate my huge database (structure and data) from MySql to MSSQL Express (after 4 years now i hate mysql). I don't want...

PadovaBoy (ovvero Giovanni)

07-17-2008 08:01 AM
Jean-Pierre Gutsatz \(DMC\)

I have a very simple result set displayed in a Grid in Microsoft SQL Server Management Studio (2005) that I want to save as a CSV file. I right click...

kwdavids

07-15-2008 06:32 PM
Erland Sommarskog

I am running Windows Vista on a new Dell computer with both the Developer and Expression versions of SQL Server 2005 installed and I am...

Daniel Grassick

07-15-2008 02:45 PM
S J

....how do I get this back? It is greyed out. I change the registration name to work with replication but now I noticed that the maintenane jobs...

Albert H.

07-15-2008 12:05 PM
Albert H.

Hi I'm a newbie in the SQL world I have to shrink the transaction Log of an SQL 2000 Database So I googled around and found that I have to use the...

Dave

07-15-2008 10:39 AM
Ekrem Önsoy

Alan arvostuksesta kertoo varsin suoraan se miten alan ammattityöväestö suhtautuu tekemiseensä. Siitä voidaan ottaa esimerkkejä...

Herman Koskinen

07-15-2008 10:20 AM
Herman Koskinen

Ok - I made a mistake when typing in the database name. The database does exist and does not error when I do use NewDB go Sorry for the wrong left...

Rob Hill

07-14-2008 11:13 PM
Rob Hill

Hello, Does anyone know of any tools which perform various design, best practice checks on a database? Something that looks at the schema, table...

eschneider

07-14-2008 06:41 AM
Jean-Pierre Gutsatz \(DMC\)

When using SSMS to create a new db , I find the "File Name" boxes to be greyed-out ... How to specify .mdf .ldf filenames other than the default ?

John A Grandy

07-13-2008 07:38 AM
Ekrem Önsoy

Is there a tool available to script data ? e.g. Table1 has 10 rows , so the tool would script 10 insert into statements

John A Grandy

07-12-2008 01:49 AM
Tibor Karaszi

SQL 2008 rc0 I want to give a remote business partner access to my data on my home network. I would prefer to NOT open port 1433 on my firewall,...

Andre

07-11-2008 04:32 AM
Erland Sommarskog

-- Everyone needs assistance, especially when checking brake, and reverse lights! Hello All, I need to send Feedback on the SQL Server 2008 using...

Louis205

07-07-2008 09:51 PM
Louis205

how do i find out what process could have caused a transaction log to fill up possibly over hte last 24 or 48 hours? thanks in advance

lark

07-07-2008 06:35 PM
Erland Sommarskog

Hi there, a very simple question: I can't find the SSMS component during the Server 2008 RC0 installation process. Is it on a separate download...

Oriane

07-07-2008 03:17 AM
Charles Wang [MSFT]

I'm using "Transfer Logins" task in SSIS package to copy SQL logins from one server to another. Some logins no longer exist in Active Directory and...

Leon Shargorodsky

07-04-2008 03:01 PM
Ross Mistry

im finding for sql backup program could you offer that small scheduler program to backup

g

07-04-2008 12:58 PM
Ekrem Önsoy

DBTyP.NET 2008 Release 3 Vienna, Austria - June 28, 2008 Today, BYPsoft announced the availability of DBTyP.NET 2008 Release 3, the newest version...

dlm@bypsoft

07-03-2008 05:27 PM
dlm@bypsoft

I was finally able to correct it by removing the registery key for...

mbaker_mb

07-02-2008 11:22 AM
mbaker_mb

I have scripted my whole database and one of the parts that is installed in two different database applications is the ASP.NET Membership schemas....

....DotNet4Ever....

07-01-2008 06:58 AM
....DotNet4Ever....

Hello! We're excited to announce that Yohz Software is featuring SQL Image Viewer on Bits du Jour, a 'deal-of-the-day' website that offers...

Ray Mond

07-01-2008 01:48 AM
Ray Mond