I use the computer and the Net on a regular basis but I don't know a whole lot about it all, especially when it gets technical. I have an Acer...

Virgina Hernandez

01-27-2010 01:36 PM
Virgina Hernandez

I've got a table with >100 columns, with an identity column as the first (each record contains a set of setting values for external hardware, and...

Luc

06-25-2009 05:09 AM
Luc

Hi, I use VB 2008 as front end, SQL Server 2005/2008 as back end, I want control number of cucurrent users log on to the database, I am trying to...

kai

10-07-2008 07:01 AM
kai

Tom Gugger Independent Recruiter tgugger (AT) bex (DOT) net 419-537-9447 MS/SQL Developer--DTS—Contract—Detroit Area My client has a DTS problem...

Tom Gugger

09-06-2008 10:19 AM
Tom Gugger

Is it a good idea to create a DLL API for DB connection + DB query calls? I guess it's the same for creating it in VC++ static library? so my DLL...

Jim Johnson

03-26-2008 07:42 PM
Jim Johnson

TOM GUGGER INDEPENDENT RECRUITER tgugger (AT) bex (DOT) net 419-537-9447 MS SQL SERVER DBA/ CONTRACT/ INDIANA We have an immediate need for a MS...

TOM GUGGER

03-15-2008 09:31 AM
TOM GUGGER

Almost free www.dashsql.com - SQL stored procedures and c# code generator Hope it helps! www.dashsql.com

Dashsql.com

08-13-2007 10:26 PM
Dashsql.com

Hello, I'm trying to find out if I can configure SSRS 2000 to function with a separate web server? When I installed SSRS 2000 it ran a system check...

Rico

07-24-2007 01:22 PM
Norman Yuan

Sorry, it would help if I looked through the 1500 MSDN binders we have here on the shelf! "Rico" <me (AT) you (DOT) com> wrote

Rico

07-24-2007 11:47 AM
Rico

Our web site performs numerous updates, inserts, deletes and the site is quite heavily used. From time to time users are receiving an unusual...

Mark Findlay

05-10-2007 12:11 PM
Mark Findlay

I am attempting to run a 2 computer upgrade from SQL Server 6.5 to SQL Server 2000 over a workgroup LAN. When I run the Server 2000 Upgrade Wizard,...

TomH

11-18-2006 12:08 PM
TomH

I just went to the MS VS 2005 Launch and got a free copy of SQL Server 2005 Std Edition. and I installed it. Stupid Question: Where the hell is the...

Chad Dokmanovich

10-30-2006 09:24 AM
Benedikt Ries

Someone here tested MS SQL Server vs. MySQL. Both stock install versions, no tweaking. The result of tests, roughly, is that MySQL is about 2-3x...

Ignoramus7272

10-09-2006 10:39 AM
Ignoramus24560

Hello: I am trying to develop a cube in MS OLAP to do Last Month- This Month type of comparison analysis. One way to do this is to have a column...

sxd213

08-21-2006 11:03 PM
sxd213

A project I'm working on has a daily update of a table and then reapplies each day a table of updates called EditHistory. What's the best way to do...

bob

08-12-2006 03:43 PM
bob

I created an indexed view in SQL 2000, and I expected to see the index created on the view referenced in the execution plan when I query the view....

tomstone_98

08-11-2006 02:02 PM
tomstone_98

I have to create an active active sql 2005 setup questions do I have to run the cluster wizard on each node? do i run it 2 on the first node? do i...

mapleleaf

08-08-2006 10:26 AM
mapleleaf

I'm attempting to export data to a dynamically named excel file everyday. For the most part it all is working well other than when the DTS package...

sbarrow

07-20-2006 10:36 AM
sbarrow

Hello @all, I have got a strange error during the automated proecssing of my SSIS-Package. It is a MS Windows Server 2003 64bit Edition and a 64 bit...

M_Oelsner

07-20-2006 01:56 AM
M_Oelsner

I m trying to write a function that calculates date difference as follows: ALTER FUNCTION dbo.daycount(@startday DateTime) RETURNS Integer AS ...

axism

07-16-2006 07:36 PM
Dave Owen

Hi, need help urgently in resolving the follow issue for ms sql 2005. Unable to startup the databases. Following is a summary of the error in the...

achoonho

07-14-2006 07:33 AM
achoonho

Can someone please tell me how to do the following: I have three tables, each table has the same fields. Each table has an "ItemNumber" field but...

ww

07-05-2006 02:00 AM
scott.x.lu

For part of a school project, I have to write a query to answer: Which students are enrolled in both Databases and Networking? (Hint: Use...

Patrick

07-05-2006 01:40 AM
scott.x.lu

What is the correct syntax for querying the first 20 characters of a memo field? I'm trying to SELECT CAST (varchar(20) fieldname) as...

T.M.

07-05-2006 01:26 AM
scott.x.lu

Hello all, I've got a kludge of a VB6 application that does: 1.) Read a table to get the next batch number . Result is read into a recordset called...

JdiazAZ

07-05-2006 01:23 AM
scott.x.lu

Calling diffrent database table in storedprocedure is getting problem when i calling from ASP 3.0 , when i executing SP from ASP its executing but...

Chandra

06-15-2006 01:46 AM
Chandra

I have a database with a number of fields (things like postal address) that were originally (mistakenly) created as TEXT and that only need to store...

dcutter

06-09-2006 06:47 PM
dcutter

I've inherited a db that has a table of salespeople with a field called Territory. Territory contains a list of states that each...

Doug

06-01-2006 10:02 PM
scott.x.lu

Good Afternoon Everyone! I'm working on a project where I need to basically combine 8 servers' information into one server. There are two tables...

bkbroiler2k

05-10-2006 05:51 PM
bkbroiler2k

Hi, Can anyone advise on the way forward to resolve a permission problem? Details: Publisher has publications configured with subscribers accessing...

daniels

05-08-2006 01:28 AM
daniels

Hi, I am a local admin on this box. I can excute DTS package manual without any errors. But, when I schedule it to run, I will get the follow...

axism

05-05-2006 10:44 AM
axism

Hi I have problems when converting a float value to a datetime value in the SQL clause on a SQL Server 2005. The date always is two days wrong,...

BobAndersson

05-04-2006 07:31 AM
BobAndersson

Is there a way where you can programmatically (via visual basic) replicate two or more SQL Express databases located on multiple computers without...

pixeldrop

05-03-2006 11:11 PM
pixeldrop

Hello, I have SQLServer 2000 (SP4) and MDAC 2.8. I have a problem, when I connect to SQLServer with SqlDriverConnect, amount of memory is increased...

iestudi

05-02-2006 08:55 AM
iestudi

Migrate-Data is a pure java and an extremely powerful enterprise data migration tool aimed at small and medium sized databases. It has been developed...

pravumishra

04-23-2006 11:59 AM
pravumishra

I want to use SSIS to do a normalization process for me. I have a single source table that need to be broken out into multiple destination tables. ...

tward

04-07-2006 12:24 AM
tward

I have a asp.net whereby user can dynamically create a sql statement by choosing the columns and tables names. I will then use a stored procedure to...

reenz

03-30-2006 08:05 PM
reenz

ARGH! Thanks Brian, I managed to fight through that (was my inexperience with SQL 2005, (defining the Logins before defining the Users). Now I'm...

Rico

02-06-2006 12:15 PM
Rico

Does anybody know of a good tool for converting a foxpro database to MS sql2000?

Ray

11-14-2005 08:54 PM
Ray

What is the unit of CPU column in sysprocesses? Thanks

Sean T Shen

10-22-2005 08:34 PM
Sean T Shen

Hi MS SQL users, I am just start using MS SQL Server. And somebody told me this is the best DBMS on the planet. Well that is easy said of course. I...

Sander Rensen

07-25-2005 04:36 PM
Patrick Sullivan

I have as SQL Server 2000 running on a Windows 2003 box I use a c# windows application accessing the database running from an XP machine also with...

Paul Johnston

05-06-2005 03:15 AM
Paul Johnston

I hope I can get this across clearly. I have a table that needs to be broken into 3 tables. Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col1 and Col2 need...

The Bear

04-20-2005 12:38 PM
David Gugick

Hi, We are a team that are developing a projet which has in itself a good number of tables in sql server (not temporary ones !). The entire team is...

genc_ymeri

04-15-2005 03:50 PM
Hugo Kornelis

TOM GUGGER ERP SOLUTIONS INC 560 BRONX DRIVE TOLEDO, OH 43609 (419) 380-8853 tgugger (AT) buckeye-express (DOT) com

Tom Gugger

04-09-2005 01:27 PM
Tom Gugger

Hi all - I'm trying to track down why Access (ACC2000) will not throw an error when the user does not have a login on the SQL server (SQL Server...

chris ciotti

02-11-2005 07:12 AM
chris ciotti

I need help building a data base and parts of a web site. Please email me if you can offer some assistance.. TIA

CPS

02-08-2005 06:22 PM
CartmanLabs

Hi have a small network setup and have MS sql server on workstation. Can access it locally but cannot access it from other work stations. I am...

Father Jack Hackett

02-08-2005 05:37 PM
CartmanLabs

How can I print the structure of a table from Enterprise Manager? Or is there another app that has a print option? Also, I tried to connect to the...

MacKenzieMouse

01-25-2005 03:55 PM
MacKenzieMouse

Altova Unveils DiffDog(tm) 2005 ------------------------------- This week, Altova added a new dedicated differencing utility to its award-winning...

Altova Announcements

01-18-2005 08:52 AM
Altova Announcements