I hosed myself, please help me somebody. We have a development server (SQL7) where the database is a restored copy of production (where we use...

David Rawheiser

01-05-2005 09:32 PM
David Rawheiser

I was wondering if anybody has a document that states do's and don'ts when programming for a MS SQL DB. I was under the impression that Microsoft...

ryankbrown@hotmail.com

01-05-2005 06:39 PM
ryankbrown@hotmail.com

Hi, I was using enterprise manager to generate a script for my DB. I scripted only my tables and views and in Options I picked all the options...

drdeadpan

01-05-2005 04:39 PM
Erland Sommarskog

I'm trying to create a login in the default domain. I know I can pull this information from xp_loginconfig, but don't see how I can use it in the...

Aaron

01-05-2005 04:33 PM
Aaron

Just wanted to know what is a general rule of thumb when determining log file space against a database's data file. We allow our data file for our...

Jeffrey Sheldon via SQLMonster.com

01-05-2005 03:23 PM
getinked

Hello all. I created the "student2" user account except that in Step 5 I used SQL Server Authentication and set the password to "student2". I...

Jim Richards

01-05-2005 01:49 PM
Jim Richards

Hello all. I created the "student2" user account except that in Step 5 I used SQL Server Authentication and set the password to "student2". I...

Jim Richards

01-05-2005 01:39 PM
Jim Richards

Hello all. I created the "student2" user account except that in Step 5 I used SQL Server Authentication and set the password to "student2". I...

Jim Richards

01-05-2005 01:36 PM
Jim Richards

I have XP workstations and windows 2003 SBS. I setup an ODBC for an application (tried both User and System DSN), but after a few usage, I get the...

!!bogus

01-05-2005 12:40 PM
John Bell

Hi, I've just started using ADSI to pull in info from our Active Directory tree into SQL Server 2000. I've made the link ok, and can pull in...

Ross Luker

01-05-2005 11:00 AM
Simon Hayes

Folks, We're implementing a software based mirroring solution. This solution requires that the SQL Server service on the target server be...

ceadtinneh

01-05-2005 10:33 AM
Simon Hayes

Hi everyone. I have a question that maybe some of you may be able to shed some light on. My set up involves three SQL Server Databases. First one,...

guevara_81@yahoo.com

01-05-2005 10:18 AM
guevara_81@yahoo.com

I guess I don't fully understand what IIS does/is! I can appreciate the need for the host/server to be running IIS but it 'appears' restrictive for...

Phil

01-05-2005 09:57 AM
Andy O'Neill

Is there a way to back up the design changes in a SQL Server database without backing up all the data? It's just test data at this point.

Jerry Porter

01-05-2005 09:34 AM
Matt

from the December 2004 _Redmond Magazine_, "Finding Gold in Yukon": http://redmondmag.com/columns/article.asp?EditorialsID=838 "Developers will also...

Ross Presser

01-05-2005 08:26 AM
--CELKO--

Hi all; I am trying to replicate our database by using the merge replication. SQL Server Group however I wasnt able to create the conncetion...

laststubborn

01-05-2005 05:00 AM
Simon Hayes

Hi, I have a peculiar problem (or maybe not). I have SQL clients installed on XP boxes. These XP boxes are a member of let us say "XYZ" domain. SQL...

Vinodi

01-05-2005 02:39 AM
Vinodi

Tom Loach wrote: Tom, This feature is in SQL but hidden and hard to find. Open a server in Enterpise Manager and drop down a database. Select a...

Mad Matt

01-04-2005 05:16 PM
Mad Matt

I have a log file that went out of control (147GB), I feel that doing a shrink on the file/database would be time consuming so I am thinking of...

Jeffrey Sheldon via SQLMonster.com

01-04-2005 05:08 PM
Erland Sommarskog

Hello all, Over the years as I design more database schemas the more I come up with patterns in database design. The more patterns I recognize the...

Don Vaillancourt

01-04-2005 04:41 PM
Erland Sommarskog

I have a complex query (16 table join) that until five days ago took 30 sec to run. It now takes eight hours. I restored a backup of the database...

tracy@guisolutions.com

01-04-2005 04:35 PM
Erland Sommarskog

Hello, I am setting up log shipping between two SQL servers. Everything in the setup seems to work fine. The problem I am having is that the...

Tim Groulx

01-04-2005 02:50 PM
tgru

Because of an error in google or underlying site i can reply on my own issue. Therefore i copied the former entered message in this...

Hennie de Nooijer

01-04-2005 02:19 PM
John Bell

Hi, I have the following piece of code which iterates through the potential errors: i =0 For Each error_item in...

doli

01-04-2005 02:05 PM
doli

Is there a way to back up the design changes in a SQL Server database without backing up all the data? It's just test data at this point.

Jerry Porter

01-04-2005 01:41 PM
Jerry Porter

Hi, I am using Merge Replication for synchronizing a bunch of laptops running MSDE with a central SQL Server 2000 production server. This database...

miltonmoura@gmail.com

01-04-2005 08:26 AM
Simon Hayes

Hi All, I have several questions about checking backup file : a. When SQL Server receive a command : BACKUP DATABASE test to DISK =...

John S

01-04-2005 08:06 AM
Dan Guzman

Hello All, I am currently creating a browser interface for our thick client which was built on Visual Basic using COM ( a three tier environment)....

sss

01-04-2005 06:58 AM
pcapcanari@gmail.com

The field itemdate is a datetime field in sqlserver2000 DB This works fine: Select Id From BookData Where (MONTH(itemdate) = '01')...

sdowney717@msn.com

01-04-2005 12:58 AM
sdowney717@msn.com

SQL 2000 Windows 2000 sp4 I have created a group called "queryonly" in Active Directory. I have added myself to this group. When I attempt to create...

Justin

01-03-2005 08:39 PM
Michael van der Veeke

Hi All, I want to shrink a transaction log using : USE Master BACKUP Log test WITH truncate_only USE test DBCC shrinkfile(test_log, 0) These...

John S

01-03-2005 04:57 PM
Simon Hayes

I have a table I insert a record into to give access to a user. It uses primary keys so duplicates are not allowed, so trying to add a record for a...

wackyphill@yahoo.com

01-03-2005 04:57 PM
Erland Sommarskog

I am doing a monthly report to export to an excel Doc from SQL 2000 using views. With my design it works great until it is the first of the month. As...

Mike Lander

01-03-2005 03:37 PM
Hugo Kornelis

i use set nocount on inside the stored procedure at the beginning however the Number of Rows Counted/Affected shows up when I execute the...

GM

01-03-2005 02:02 PM
Simon Hayes

I want to grab what is in textbox1, put in string, and send as a query to bring up report with only textbox1 occurances in table. How do I do that...

trint

01-03-2005 12:42 PM
Simon Hayes

I have SQL Server desktop installed on my laptop. I have a database on these that i created. but when i try to back it up to disk, i have...

WOODY

01-03-2005 12:40 PM
Simon Hayes

I have this query that I would rather not turn into a stored proc. because the client really has no budget. I was hoping there would be a way to add...

hobo

01-03-2005 10:40 AM
hobo

Hi, I've got problems using ntext data in a stored procedure (SQL-Server 2000): create procedure testproc @xmldata ntext as declare @Param ntext

Tom

01-03-2005 10:13 AM
Tom

Hello all. I have an administrative account setup in Win XP Pro and I also have a user account named "Jim Richards" (kinda logical, huh?). I...

Jim Richards

01-03-2005 09:38 AM
Jim Richards

Hi all, i'm writing an application that use data form a database from mssql2000. I need to let my application read and write data in to the db but...

Sergio Sbracia

01-03-2005 09:30 AM
Sergio Sbracia

Hey...I've been cracking head about this one all day, and I'm sure it's an easy answer, but here goes: I have a column entitled Sequ which is...

erikthenomad@hotmail.com

01-02-2005 05:20 PM
Hugo Kornelis

In EM that is, in QA if I use: use master select * from sysdatabases I get: (6 row(s) affected) Server: Msg 220, Level 16, State 1, Line...

Trev@Work

01-02-2005 05:00 PM
mimorr

I want to reformat my servers harddrive and install a newer operating system (Win 2003). I am running SQL Server 2000 with about 10 databases. What...

Rick

01-02-2005 04:41 PM
Erland Sommarskog

I have MS SQL server 2000 with MOM server. I was able to shrink the database file, but when i try to shrink the log file i fail. I use "shrink...

Moti.Ba@gmail.com

01-02-2005 04:40 PM
Nigel Rivett

Hello all. I have an administrative account setup in Win XP Pro and I also have a user account named "Jim Richards" (kinda logical, huh?). I...

Jim Richards

01-02-2005 04:38 PM
Erland Sommarskog

Greetings All, I was wondering what would happen if I were to do a "select * from table" on a table that has about 5 million rows. Would my read...

LineVoltageHalogen

01-02-2005 02:27 PM
Gert-Jan Strik

Hello all. I have an administrative account setup in Win XP Pro and I also have a user account named "Jim Richards" (kinda logical, huh?). I...

Jim Richards

01-02-2005 11:29 AM
Jim Richards

When I export a report to PDF format, the bookmarks pane is closed, and needs to be pressed in order for the bookmarks to open. Is it possible that...

Alon

01-02-2005 09:19 AM
Erland Sommarskog

I know that a query inside a called UDF does not show up when displaying the estimated query plan, but are the resources (CPU, DiskIO) used by a UDF...

Ray

01-01-2005 04:58 PM
Erland Sommarskog

Perhaps this has already been answered. If so, I apologize. I'm a newbie at this stuff. I have a DTS package to import some Visual Foxpro data. ...

emily

01-01-2005 04:19 PM
Erland Sommarskog