I have a content site where everything is currently in one SQL Server DB. As I add features to the site, for example message boards and blogging,...

Erik Lautier

12-19-2006 02:25 AM
Erland Sommarskog

Hi! I have a batch file (.bat) that I need to execute inside my stored procedure (SQL 2000). I am trying to call that batch file using xp_cmdshell...

tolcis

12-19-2006 01:44 AM
Thyagu

Hi, When I run the following command on sql server: exec ('print "OK"') go This message appears: Server: Msg 128, Level 15, State 1, Line 1

findu_2005@yahoo.com

12-19-2006 01:39 AM
Thyagu

I have one of our production Accounting Databases starting from 2 GB now grown into a 20 GB Database over the period of a few years... I have been...

Query Builder

12-18-2006 04:37 PM
Erland Sommarskog

Execute following T-SQL within Queary Analyzer of SQL Server 2000: ======================================= DECLARE @dTest DATETIME SET...

aling

12-18-2006 03:04 PM
Gert-Jan Strik

I need to separate files into to specific file groups to spread across several raid 1 devices. Since database admin is a new concept to me I would...

dave1678

12-18-2006 01:23 PM
dave1678

- comp.databases.ms-sqlserver - microsoft.public.sqlserver.odbc - microsoft.public.sqlserver.server I installed "SQL 2005 Express with Advanced...

PBsoft

12-18-2006 06:13 AM
PBsoft

I have a MSSQL2000 box with a large database containing circa 150 SP's. I want to move the DB to another SQL machine, but many of the SP's...

testbox@magaff.co.uk

12-18-2006 05:42 AM
Erland Sommarskog

Hi to everyone, My problem is, that I'm not so quite sure, which way should I go. The user is inputing by second part application a long string...

Matik

12-17-2006 05:43 PM
David Portas

The following query works fine in access and does exactly what I want it to do however I get a syntax error when I port it over to SQL...

info@bodykind.com

12-17-2006 05:15 PM
Erland Sommarskog

Hi, I am not able to execute following command from computers other than the SQL server itself. select * from openrowset(bulk...

Gugale at Lincoln

12-17-2006 09:54 AM
Dan Guzman

To add on to Erland's response, excessive parallelism can be a symptom that query and index tuning is needed. The optimizer will sometimes...

Erland Sommarskog

12-16-2006 08:47 AM
Dan Guzman

Hello, I'm using a multipart/form-data upload to put an image into SQL Server, and it appears to be working, but I'm unable to display the image. ...

Erik Lautier

12-16-2006 04:55 AM
Erland Sommarskog

I need some help to solve this problem with some stored procedures. Sens we use ControlM I need to schedule jobs there and not in SQL. With a simple...

joel.sjoo@gmail.com

12-15-2006 10:27 AM
Erland Sommarskog

Table A Table B BOL# ...

Rnt6872

12-14-2006 10:20 PM
othellomy@yahoo.com

Hi group I'm not familiar with the name, newbies user. The SQL key is call Row # ?? if that correct can it be possible to create a new record and...

JF Fortier

12-14-2006 10:01 PM
othellomy@yahoo.com

I cannot block user access to tables. I have restriced accounts at the server, database, group, schema, and table lavel and can still open tables...

Bergs

12-14-2006 04:46 PM
Erland Sommarskog

I am new to SQL and have created a stored procedure for a .net web application. Unfortunately I had to use a cursor in the stored procedure, so it...

Patti

12-14-2006 04:41 PM
Erland Sommarskog

Claim number (string) CF060001 CF060001A CF060001B AV000001 AV000212F AV000001F FD232122 FD232122G SD223213

TGEAR

12-14-2006 04:36 PM
Erland Sommarskog

Hello All, I have a sql statement that I'm using to match records on. But i need to use a substring to get the nuber that I need, and I have to...

Rnt6872

12-14-2006 11:11 AM
Matik

When you create data files and filegroups, you specify a size. My question is -- how do you know how full they are? Is there a stored procedure...

caseahr

12-14-2006 08:16 AM
caseahr

Hello all, I hope someone can help me; if got a value in a cell (040 1234567), when I run a query in the Analyser I got as respons only 40 1234567,...

Marko

12-14-2006 04:20 AM
Erland Sommarskog

I received a few cd's from a client, with a .bak MS-SQL database backup, installs for tomcat, and java. Everything was provided via an altered...

smoscar@gmail.com

12-13-2006 05:05 PM
Erland Sommarskog

I am trying to connect to SQL 7.0 northwind database via visual studio 2005. But I can't open the connection. I get an error saying remote access is...

podx

12-13-2006 05:01 PM
Erland Sommarskog

I've just been looking at a new 2005 install and found 3...

Laurence Breeze

12-13-2006 04:42 PM
Erland Sommarskog

Hi, Please can you help me with this query which I am struggling with? Here is a simplified version of the table I am trying to work with VehicleId,...

roberthornsby@hotmail.com

12-13-2006 07:55 AM
Roy Harvey

I am struggling with converting a certain varchar column into an int. I have a table that has 2 fields - one field holds the loan number and the...

Patti

12-12-2006 10:25 PM
Ed Murphy

Hi. I have the problem that some records in a ms sqlserver table is unable to update from Access. I get the error message odbc-time out error in...

olle@ylm.se

12-12-2006 04:49 PM
Erland Sommarskog

comp.databases.ms-sqlserver, Stylus Studio has published a new educational video tutorial entitled: Visual Data Integration Using Stylus Studio XML...

Stylus Studio

12-12-2006 01:28 PM
Stylus Studio

Dear borland.public.delphi.xml, Stylus Studio has published a new educational video tutorial entitled: Visual Data Integration Using Stylus Studio...

Stylus Studio

12-12-2006 01:27 PM
Stylus Studio

please help, I need professional approach how to realize generalization (parent_table <- child_table) idea in sql server databse? in my Oracle db I...

fireball

12-12-2006 11:28 AM
David Portas

Introduction Usability and relevance have been identified as the major factors preventing mass adoption of Business Intelligence applications. What...

YellowFin Announcements

12-12-2006 05:22 AM
YellowFin Announcements

I have found that orig tested 64 bit on our 64bit windows 2003 server...about 1 year ago...and company decided to use sql 32 bit on the 64bit os my...

mike

12-11-2006 05:59 PM
mike

ttt.tas (AT) gmail (DOT) com schrieb: field is encrypted, i.e. a database full of nonsense? Why can't he just give you the table structure and let...

Volker Hetzer

12-11-2006 05:46 PM
David R. Tribble

We developed a DB for our customer using MS Access and upsized it to SQL Server. Our customer does daily back up of his DB and he asked me whether or...

mfine@array.ca

12-11-2006 02:10 PM
rcamarda

I have the following stored procedure that is called from the source of a transformation in a DTS package. The first parameter turns on PRINT debug...

Bill_DBA

12-11-2006 09:43 AM
Bill_DBA

I want to create a stored procedure to find if the index exists if not i have to create the index....i use following stored procedure....but does'nt...

frien

12-11-2006 01:19 AM
David Portas

If you display the execution plan and run the following: SET STATISTICS IO ON go SELECT ProductID, SupplierID FROM Products WHERE SupplierID = 1

serge

12-10-2006 09:29 PM
serge

Apologize for posting on this forum but I did not find any other forum to address all my peers in the IT world. I would like to welcome you to <B><...

TruthSeeker

12-09-2006 02:59 PM
TruthSeeker

Hi everyone, I am really struggling to do the following in sql. Your expertise will be very welcome. I have a table below IndexId ...

patelk23@gmail.com

12-08-2006 05:17 PM
Erland Sommarskog

This one cost me a solid half hour yesterday. I'm wondering why on earth the default precision for a decimal type is 18,0. Maybe I'm mistaken. A...

Boot2TheHead

12-08-2006 05:11 PM
Erland Sommarskog

can anybody plz....help in a stored procedure..............i basically need a simple stored procedure to see if a index exists in the table if it it...

frien

12-08-2006 05:00 PM
Erland Sommarskog

I have the following stored procedure that is called from the source of a transformation in a DTS package. The first parameter turns on PRINT debug...

Bill_DBA

12-08-2006 09:44 AM
Bill_DBA

Help; Im New with a company and the sql server is maxing out the cpu's We have 3 web servers load balanced.... large volume of data the current...

mike

12-08-2006 09:15 AM
mike

Hi, I have written some batch scripts using osql to run some sql statements. They are basically something simple (such as running a stored procedure...

akkha1234@gmail.com

12-08-2006 07:47 AM
Madhivanan

I'm not sure if this is a completely dumb question, but please humor me :) I have a table of records, called Records, each of which has a Category_ID...

FrankEBailey@gmail.com

12-08-2006 07:44 AM
Madhivanan

I read this and got confused... I use PHP and got this: $sql = "delete from blabla where startdate<...

Sonnich

12-08-2006 07:40 AM
Madhivanan

Hi All, I think this is a thorny problem, and I'm hoping you can help. I've not found this exact issue described anywhere yet. I have a stored...

Tim Satterwhite

12-08-2006 01:50 AM
Tim Satterwhite

We have 20 -30 normalized tables in our dartabase . Also we have 4 tables where we store the calculated data fron those normalised tables. The Reason...

meeraguna@gmail.com

12-07-2006 09:23 PM
Alex Kuznetsov

We are installing an application that requires access to the ms-sql-m protocol (UDP/1434) as well as the data port (TCP/1433). The SQL Server we are...

ddnash@gmail.com

12-07-2006 02:13 PM
ddnash@gmail.com