Hello, Is there any date decided by microsoft for the phase out of Sql server 2000? Cheers, Jiten ...more >>

Thank you for your reaction Raghu Bhandari... This was not exactly what I have to know. Suppose you have to import 16 files and there's is an error (a missing field, or a text instead of an integer) inside the fourth file. In that case, I want to restore my database in it's original state. I ...more >>

or a table returning function. ...more >>

When I open QA on my development machine, I almost always go to the same db. Is it possible to create a shortcut for QA which tells it to go to that db, and also provides the login and password? Thanks, Neil ...more >>

Hi Mobileboy, You can avoid such errors by making use of the udf_CheckFileStatus function shown below. ------------ while 1=1 begin print getdate() print 'Status='+Convert(varchar(1),dbo.udf_CheckFileStatus('D: \PERFMON.CSV') ) if dbo.udf_CheckFileStatus('D:\PERFMON.CSV') =0 begin ...more >>

Hello Group, I'm using SQL Server 2005 SP1. I have to import 16 text files every day. If there's an error in 1 of the files, I need to perform a rollback, so that the datase is back in it's original state. I tried a structure like this one (I dropped all the details) BEGIN TRY BEGIN...more >>

andydlove@gmail.com wrote: > I need help with a table I have. It looks something like this: > > Log | Var1 | Var2 | Var3 | .....| Var300 > ----------------------------------------------------- > 1 | Data > 2 | Data > 3 | Data > > I want to rework the table so it reads: > > Log | Va...more >>

jcriswel@gmail.com wrote: > Is there any way to call a view from a client program and pass > parameters to the server to filter the view before the result of the > view is returned to the client? I know that stored procedures have > paramaters and an ADO recordset can be populated with a para...more >>

On Oct 25, 1:01 pm, andydl...@gmail.com wrote: > Hi guys and gals, > > I need help with a table I have. It looks something like this: > > Log | Var1 | Var2 | Var3 | .....| Var300 > ----------------------------------------------------- > 1 | Data > 2 | Data > 3 | Data > > I want to rewor...more >>

Hi guys and gals, I need help with a table I have. It looks something like this: Log | Var1 | Var2 | Var3 | .....| Var300 ----------------------------------------------------- 1 | Data 2 | Data 3 | Data I want to rework the table so it reads: Log | Var | Data ---------------------...more >>

Running SQL Server 2000. I want to create a scheduled job that will export all the tables in a database to Access. Yes, I know about DTS, but here's the thing... Once I set up the DTS package, if I add a new table (or a just add a new column to an existing table), that DTS package isn't going...more >>

Thanks for adding that info. "Erland Sommarskog" <esquel@sommarskog.se> wrote in message news:Xns99D2F206743A5Yazorman@127.0.0.1... > Greg D. Moore (Strider) (mooregr_deleteth1s@greenms.com) writes: >> No, and there never has been. That's a misunderstanding of the old >> query governer bu...more >>

Thanks for the info. That's good to know. "Greg D. Moore (Strider)" <mooregr_deleteth1s@greenms.com> wrote in message news:13hrn2sbia0lt74@corp.supernews.com... > "Neil" <nospam@nospam.net> wrote in message > news:G0hTi.54$nN3.12@newssvr17.news.prodigy.net... >>>>> (BTW, you may want to loo...more >>

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message news:Xns99D2F206743A5Yazorman@127.0.0.1... > Greg D. Moore (Strider) (mooregr_deleteth1s@greenms.com) writes: >> No, and there never has been. That's a misunderstanding of the old >> query governer built into MSDE (whcih permitted...more >>

Greg D. Moore (Strider) (mooregr_deleteth1s@greenms.com) writes: > No, and there never has been. That's a misunderstanding of the old > query governer built into MSDE (whcih permitted only 5 or 6 (I've seen > both numbers)) of queries to run at the same time before things were > slowed down on ...more >>

On Oct 11, 8:18 am, Matt <mdw...@gmail.com> wrote: > Hi All, > > I have a few questions on transferring data between SQL Servers > (please keep in mind I am using Express 2005). > > Situation: > ----------------------------------------------------- > I have a SQL Server database on my server...more >>

This question probably reveals a basic misunderstanding that I have about client server architecture so please take my confusion into consideration with your reply. Is there any way to call a view from a client program and pass parameters to the server to filter the view before the result of t...more >>

Hi, I'm facing a problem when some users are uploading data to our SQL 2005 database. A sp is creating a temp table. Data (a flat file) is just bulk loaded into that temp table. An update is then performed by executing an update statement which is joining the main data table with the temp ta...more >>

On 18 Oct, 21:31, Bj=F6rn Pettersson <bjope...@gmail.com> wrote: > Hi, > > I've been searching on the net for general recommendations regarding > memory, for quite some time, but without any luck. I am sure there are > some neat formula out there to calculate how much memory a server need > fo...more >>

>>> (BTW, you may want to look into upgrading the DB to use something like >>> SQL Express edition. More modern, better supported and may be a bit >>> faster, especially on a Windows 2003 box.) >> >> SQL Express? I thought SQL Express was the new version of SQL >> Desktop/MSDE. Maybe I'm wr...more >>

"Neil" <nospam@nospam.net> wrote in message news:G0hTi.54$nN3.12@newssvr17.news.prodigy.net... >>>> (BTW, you may want to look into upgrading the DB to use something like >>>> SQL Express edition. More modern, better supported and may be a bit >>>> faster, especially on a Windows 2003 box.) ...more >>

"Neil" <nospam@nospam.net> wrote in message news:bTXSi.7102$Pv2.3736@newssvr23.news.prodigy.net... > >>> Since there's a big jump in the size, I was wondering if there's >>> anything >>> I need to do maintenance-wise to help the database use the new data. >> >> That's still very small as fa...more >>

>> Since there's a big jump in the size, I was wondering if there's anything >> I need to do maintenance-wise to help the database use the new data. > > That's still very small as far as SQL databases go. Right. I just meant that it was almost double the original size. Wasn't sure if there...more >>

I just made a major addition to the data in our database (SQL 7 with an Access 2000 front end). The users had been working with a set of 66,000 Word documents, having to open each to view when needed. I converted these docs to RTF format, and brought the RTF codes into the database itself. Eac...more >>

"Neil" <nospam@nospam.net> wrote in message news:z_SSi.59295$Um6.46164@newssvr12.news.prodigy.net... >I just made a major addition to the data in our database (SQL 7 with an >Access 2000 front end). The users had been working with a set of 66,000 >Word documents, having to open each to view w...more >>

Hi SQL People! I have a interesting question, just wondered if anyone had previous experiance and could offer some guidence. We have application that has one primary table that contains app ~3 million rows with 17 fields; each item has a parent child relationship (stored using a parentId co...more >>

Mukesh_Singh_Nick@yahoo.com kirjoitti: > I've come accross queries like this one previously but never got the > time to carefully study them form some book. > > SELECT 1 WHERE 1 = 1 > > I think I have seen similarly queries on some general graphical query tool. It uses the statement to ...more >>

Definitely a Kerberos ticket issue. I can see it fail and then switch to anonymous login. I have the SPNs setup for the service accounts. Still, there is no delegation tab under the service account properties in Users and Computers. This is strange because the SPN is working (I checked in ADSIEd...more >>

hi all, I have a proble with SSIS and a primary key constraint. I used the sqlserver tool to import data from a table in a db to an equivalent table on another db. My problem is that it stops because of primary key constraint on the destination table. Is there a way of telling the process to ...more >>

Hi, I've been searching on the net for general recommendations regarding memory, for quite some time, but without any luck. I am sure there are some neat formula out there to calculate how much memory a server need for a particular size of database, but that doesn't help me I would like to kn...more >>