Forum: Microsoft SQL / MS SQL Server

In our application, we need read xml from our SPs, now we are using EXEC @resultcode = sp_OACreate 'MSXML2.XMLHTTP', @objRef OUT .... to...

We discovered yesterday database corruption and with help from my previous posting we checked the database. A few tables do have problems and...

Hi, I had my Windows 2000 crashed and after that I reinstalled windows, sql server etc. after taking backup of all mdf ( and no ldfs by mistake)....

Im using a query with OrderBy clause to populate a temp table. The Query works and Order and everything is Fine But when reading the data out of...

Hi group, I have been working with COM objects in T-SQL for some time, but now I face a problem I cannot solve: I have an object with a method...

It really depends on what type of cursor you use. If you use a static cursor then you can never get anything other than a 0 since all the rows...

Hi, Anyone have a table of Countries, with their respective international dialing codes? Or, a link to such a table would be great. Thanks,...

I am running SQL Server 2000 Will trigger happen on each insert when doing a select into? From what I am finding out it doesn't. I just tried...

Hi folks, I need your help on find articles or magazines that proven using SQL Server2000 is more cost effecitve and easier to maintenance...

Hello All & Greetings. Can someone pl tell me in a hurry how I can format a currency item in 2 decimal places. thanks in advance. RK

http://www.algonet.se/~sommar/dynamic_sql.html http://www.algonet.se/~sommar/arrays-in-sql.html "Dale Fye" <spam.saic.com@nomore.dale.fye>...

Hi I have the following tables TranDetails (3rd Party) with 4 fields making up primary key Supplier char 7 GRN char 7 Journal decimal...

Hi. My problem is: I have build an "hierarquical" query that selects from a EMPLOYEES table and, for every manager, lists his/her name and in the...

If anyone could help it would be great. I am tring to install sever 2000, I run setup, get to where it asks the location of the new instance of SQL...

Hi I have a field which is a Date/Time field.... It actually only makes use of the Time portion, and this holds a duration of an activity.... ...

Calling SQL Server 2k from Access97 through ADO using sqloledb.1 Views Sorting= No Parameters= Yes Updatable= Yes Stored Proc ...

Hi, substring(newid(),0,8) "Jason Davis" <jasondavis19@hotmail.com> wrote in message news:uyGV9pFSDHA.1552@TK2MSFTNGP10.phx.gbl...

Hi, Could anyone help me create database with "sa" owner. When I login as "Administrator" in win2000 environment, the newly created data has owner...

SQL Profiler has a duration column in the output. add an event TSQL:BatchStarting to the trace If things are getting goofy, inconsistent, I...

Hello Graham, You could try using global temp tables with a "##", in your case it would be - ##UserAccess. K "Graz79"...