SQL Newsgroups: Microsoft SQL Server Administration

nightly rebooting of server

computermagic - 31 Dec 2005 7:13 PM - 3 messages

SQL 2000 patched up running under SBS2003 we shutdown and reboot automatically at 2AM into DOS and backup entire server via Ghost onto a backup and drive and restart server Question: are there any issues with rebooting SQL daily? a another consultant claims there are but I can find no mentions in MS db or ...

sqlserver start fails because db model is in the middle of a restore

Tobias - 31 Dec 2005 4:07 PM - 3 messages

Hello, i've problem with a sqlserver use by Symantec/Veritas Backup Exec. Because of a wrong setting within Backup Exec, databases are marked for restore and the server won't start with a error. I succeed starting the server with the traceflag 3807. After that the ...

SQL Server 2005 on XP workstation?

Andy Mac - 31 Dec 2005 3:09 PM - 14 messages

Can someone give me some pointers why it might not be a great idea for SQL Server 2005 to be run on an XP workstation (not server) for commercial use? And especially given that a database could be hooked up to an Internet-facing ...

SQL Memo datatype

Jason Huang - 31 Dec 2005 3:12 AM - 3 messages

Hi, In SQL Server 6.5 we have a datatype Memo, do we have the same datatype in SQL Server 2000? Thanks for help. Jason ...

CREATE FILE access denied

XCode247 - 30 Dec 2005 10:19 PM - 3 messages

I get this error message when trying to create a database. This happens from the Management Studio, from regular queries, etc. No other posts seem to resolve this problem exactly that I can find. Thanks for any insight into this problem... ...

SQL server SMTP mail

Srikanth - 30 Dec 2005 10:19 PM - 3 messages

I am configuring SMTP mail on my SQL servers. I added all my pop3 account infiormation. When i am sending an email using xp_sendmail, xp_send amil was successfull, I am not getting messages. Then i stopped the mail services and ...

Books on SQL Server 2005

imarchenko - 30 Dec 2005 7:50 PM - 4 messages

Hello! Could anyone recommend a good book on SQL Server 2005? Thanks, Igor ...

What are the effects of changing the system clock on SQL Server ?

DDLooks - 30 Dec 2005 6:49 PM - 4 messages

Hello, One of our Windows 2000 Servers is running SQL 2000 SP3. We need to advance the system date on the machine to perform some application testing. After testing is complete, we would fall back to the current date/time. How would ...

fast kill/rollback

Andre - 30 Dec 2005 5:44 PM - 7 messages

I have just killed a transaction and it says it's going to take about 20 hours to roll the change back. Is there such a thing as a "fast kill"? I don't care about rolling this back - I just want it to stop. The process is ...

Delclarative RI in SQL Server 2005

Don - 30 Dec 2005 5:33 PM - 3 messages

Does anyone know if in SQL Server 2005 declarative RI can be used to NULL a referenced field on delete of a record from the parent table? Any help is appreciated. Don ...

Query Problem

Jeff Cichocki - 30 Dec 2005 5:26 PM - 3 messages

I have the following query that is giving me an error that I can't quite figure out. The error I get is Server: Msg 8624, Level 16, State 3, Line 11 Internal SQL Server error. I think it is related to the sub-query or the ...

sql server local database question

Joe - 30 Dec 2005 5:20 PM - 3 messages

Dear all, I know than sql server express can deploy database by local database mode without installing it to the sql server Q1.) How many concurrent user for asp.net application? Can two users connect the local mode database concurrently? Since if i deploy in server database ...

Are hardware configuration stored in system databases???

Scott Yu - 30 Dec 2005 4:01 PM - 2 messages

Are hardware configuration stored in system databases??? If so, do you know of the database or tables that stores it??? Thank you. Scott ...

Need Help with Memory Issues

bradley.bill - 30 Dec 2005 3:01 PM - 22 messages

I need some help with SQL Server memory usage issue. I currently am running SQL Server 2000 Standard on Window 2000 Server Standard on an HP DL380 with 4GB of RAM. The OS is reporting the correct amt of ...

slow performance after sql update from access

jcharth - 30 Dec 2005 1:36 PM - 3 messages

Hello I ran an update query from access now the server is running slow. Can re index? what is the procedure/command for this? is it possible to disable all triggers when i run my update sql scripts? i ran profiler ...

Database size vs total table and index size

damezumari - 30 Dec 2005 12:33 PM - 3 messages

I use SQL Server 2000. My database is 1912.69 MB with no available free space. My logfile is 1 MB. The size of all tables and indexes add up to 200 MB. I have no diagrams, two views, fifty stored procedures, six users, ten ...

BOL Profiler Eventclasses not correct?!

Charl - 30 Dec 2005 7:55 AM - 5 messages

Good morning all I'm creating a table drawn from all the various books online for SQL Profiler event classes and have discovered seeming duplicates in the SQL 2005 BOL topic "SQL Server Event Class Reference" (which appeared AFTER the ...

TimeStamp

Sawlmgsj - 30 Dec 2005 7:43 AM - 2 messages

A question for Delphi experts (dare I ask it in here?) Do you know how to collect the value in a TimeStamp field? My intention is to use this value to check whether another user has updated the field whilst I have been reviewing it - and then I go to make my update. ...

Migrating to SQL Server from Versant

George Adrian - 30 Dec 2005 6:13 AM - 3 messages

Can anyone point me to someone who could advise on migrating databases. I am a system consultant (but not a database consultant or expert) and one of my customers wants to convert their database from Versant to SQL server. The ...

2-way txn replication

maxzsim via SQLMonster.com - 30 Dec 2005 6:08 AM - 3 messages

Hi, I am trying to setup a 2-way txn replication from the source & destination on SQL Server 2000 SP3. is it possible to set up such replication (i.e 2-way) and how can i do that ? tks & rdgs ...

SQL Server 2000 freeze had to reboot

SreeV - 30 Dec 2005 4:04 AM - 5 messages

Hello, We have serious issues with our production database servers once in a while we have server stops responding only option is to reboot the box to bring server online. This is going on consistently and actively working with MS ...

Float type

laurenq uantrell - 30 Dec 2005 3:31 AM - 2 messages

I inhereted a database that has a lot of Float type columns. Typically these columns hold decimal-type data rounded to four decimal points such as: 987.1234 Is Float the appropriate data type for use with these types of columns? ...

SQL Server 2005 & 2000 Same Box Hoses 2K

d - 30 Dec 2005 3:21 AM - 13 messages

Hi, After placing SQL Server 2005 60 day eval on my 2K test box, I discovered SQL Server 2000 Ent. began throwing level 21 errors and a number of counter errors appeared in the application event log. Uninstalling 05 destroyed SQL ...

Different SQL server 2000 editions

swat - 30 Dec 2005 2:59 AM - 3 messages

Hi all I am just wondering, will there be any issues if i use different SQL server editions in different environments for an application that requires a database? Meaning, this application that i hv writes to a database, and ...

dbcc error on sysobjects

sc_simsl - 30 Dec 2005 2:06 AM - 4 messages

Hi, I am getting error 8970 when I run a dbcc on my production database. Please help. Error Details: --------------- Server: Msg 8970, Level 16, State 1, Line 1 Row error: Object ID 1, index ID 0, page ID (1:92), row ID 67. Column 'uid' ...

Ghosting SQL Server 2000 Running on NT40

Scott Yu - 30 Dec 2005 12:35 AM - 7 messages

Hello, Is it possible to Ghost SQL Server 2000 running on NT4.0 and then restore that image on another server with different hardware configuration and operating system(likely Windows 2003)??? The currentl SQL Server have DTS packages, Linked Services, Jobs, etc... ...

Restore a database with 2 datafiles into one datafile - possible?

dolerud - 29 Dec 2005 10:50 PM - 4 messages

Hi, I do have a large Axapta database (114GB) with following file conent: Datafiles: d:\....\data\Axapta_data01.mdf - it is 87GB - it is in PRIMARY Filegroup f:\.....\data\Axapta_data02.mdf - it is 27GB - also in PRIMARY Filegroup Logfile: ...

Log Shipping Restore Error 3456

DavidCur - 29 Dec 2005 8:14 PM - 5 messages

Hi, I've got a production server log shipping a 280GB database to a remote DR site server. It has been running without incident for months now, but last week it stopped restoring logs (the copy process was still running) with an ...

Help with decimal numbers

alexmaia - 29 Dec 2005 7:19 PM - 3 messages

Hi! My database has a table which shows the value of the weight of some equipments. weight decimal(4,2) null But when i try to insert a value started with 0 (0.90 for an example) The value which is really inserted in my table is .90 ...

How to keep the transaction log file down to size?

john clarke - 29 Dec 2005 6:49 PM - 3 messages

Hi, our production database which is of size 30 Gigs has a transaction log file that rapidly grows by about 1 gig a day. Since there is only around 30 Gigs free space on the transaction log drive, I have implemented a job to do a backup/shrinkfile of the transaction log. ...

Msg 7404

Paul - 29 Dec 2005 6:45 PM - 2 messages

Can anyone point me to a good resource regarding SQL Server Msg 7404? I've got a scheduled job that runs a stored procedure that started showing the following after the last server reboot: Msg 7404, Sev 16: The server could not load DCOM. [SQLSTATE 42000] ...

User Defined Data type Problem

FA - 29 Dec 2005 5:34 PM - 5 messages

Hi Friends, I have a small problem hoping that you experts can resolve it. I need to make a user defined data type for a field. My field name is FINDG_NO(PK) and its datatype needs to be (Five fillers alphabatic then today's date, and then two fillers at the ...

tape backup errors

DC Gringo - 29 Dec 2005 5:25 PM - 2 messages

I'm getting the following errors in SQL logs when trying to even view the contents on my tape drive using EM: BackupMedium::ReportIoError: read failure on backup device '\\.\Tape0'. Operating system error 23(Data error (cyclic redundancy check).). Internal I/O request 0x0F32F428: Op: Read, pBuffer: 0x19D50000, Size: 65536, ...

backup tape for Win and SQL backup

DC Gringo - 29 Dec 2005 5:21 PM - 2 messages

Is it possible to use the same backup tape for both Windows and SQL Server native backups? ...

Comparing msde with sql server 2005 express.

MariaGuzman - 29 Dec 2005 5:08 PM - 3 messages

Hi, we have some applications running on a msde 2000. We are evaluating to change it to sql express 2005. Do you know if this new version support more concurrent conections than msde?? Thanks a lot for your help. *** Sent via Developersdex [link] *** ...

Copy SQL Server Objects Fails for certain views

Jonathan Orgel - 29 Dec 2005 5:05 PM - 3 messages

We have been using the 'Copy SQL Server Objects' with success for some time to copy an entire database to another server. Recent changes to our database infrastructure cause DTS to fail: 1) We have a check constraint which uses a user function (which refers to ...

time

shif - 29 Dec 2005 3:19 PM - 3 messages

Hi How can i take time > hh:mmAM/PM and time < hh:mmAM/PM from a datetime field using a select stmt. please give me a sample query for this. ...

SQL Server Locks Up Windows 2000 Server

Lee - 29 Dec 2005 3:02 PM - 3 messages

O/S = Windows 2000 Server, SP4 5.00.2195 SQL = SQL Server Standard 9.0.1399 SQL Server logs the following error in the application event log twice in 5 minutes. SQL Server has encountered 1 occurrence(s) of I/O requests taking longer ...

SQL Server crashed, DB files attached but DTS lost ...

xavito - 29 Dec 2005 2:49 PM - 10 messages

Hi, paws. My server crashed recently, I didn't give to much importance because I knew that having access to the partitions I could recover my DB files and attach my database to my new server, and everything was fine until ...

Notification Services - Where's the Magic?

Cameron - 29 Dec 2005 2:32 PM - 2 messages

I've been reading articles and working with the samples and tutorials for a few weeks now on 2005 Notification Services and I'm just not seeing the big gain. Can someone please explain how and why this is a useful tool to ...

restore from unc path from EM

kevin - 29 Dec 2005 2:31 PM - 2 messages

using sql server 2k (guess we need to specify this now) Is it possible to get EM to allow me to navigate to a UNC path. I know how to use the following and have MSSQLSERVER running under a domain account, but ...

database recovery

Chris Toffa - 29 Dec 2005 10:44 AM - 5 messages

The SBS 2003 server is blue screening. The client has not done any backup in several months. I have pluged in another HDD, installed Standard 2003 and then reconnected the old HDD as a second drive. All the data from the old HDD ...

Shrink database file

Carl - 29 Dec 2005 7:03 AM - 6 messages

Hi all, Nice problems in between x-mas and a new year! I have a database created with a setup program and with a fillfactor for all indexes on 30%. So before we discovered this, we imported about 500 MB of data into the ...

How Can I retrieve data from a self joined table

pandu - 29 Dec 2005 5:50 AM - 10 messages

hi all i have one table with the format PKEmployeeID PrimaryKey FKDeptID Salary EmployeeName FKEmployeeID here I have to retrieve the max salary by dept wise thats ok by writing ...

Removing a Filegroup

David Caddick - 29 Dec 2005 2:05 AM - 3 messages

About 3 years ago we were getting index corruptions on our SQL server database. MS and SAP indicated it was a H/W problem but HP after performing a lot of tests suggested the problem was a S/W problem. So to get the problem ...

Wierd Error in CROSS APPLY

Ganesh Muthuvelu - 29 Dec 2005 12:23 AM - 3 messages

When I run these statement below, it works. select * from fn_getsubtree(1) AS ST select * from Departments However, when I run this statement below with CROSS APPLY, I get an error: SELECT d.deptid FROM Departments AS D cross APPLY fn_getsubtree(D.deptmgrid) AS ST ...

Management Studio Solution Explorer

Mark - 28 Dec 2005 11:01 PM - 4 messages

Is it possible to set up management studio so the solution explorer is on a shared network directory? ...

Native SQL vs VB or Active X

snyper - 28 Dec 2005 10:04 PM - 2 messages

All, Sql 2000 sp4, server 2000 sp4 I have a client that has a lot of dts packages, more than I've ever seen in my life. They have a lot of activex and vb script inside the dts packages. I ...

DB Mirroring?

Joe D - 28 Dec 2005 8:52 PM - 5 messages

Any word on when DB Mirroring will be released? ...

set identity_insert permission error

N. - 28 Dec 2005 8:18 PM - 6 messages

While doing set identity_insert dbo.test on I am getting the following error: The current user is not the database or object owner of table 'dbo.test'. Cannot perform SET operation. I have the necessary insert/update/delete permissions on dbo.test table ...

Shrink log file below initial size

jxstern - 28 Dec 2005 6:33 PM - 7 messages

Actually, it's a restored copy. We have a production database with a 2gb log. We restored a copy of database and log, and the copy is 2gb. Can a DBCC shrinkfile shrink the log below the 2gb initial size? Thought so, but the guy doing it ...

sql 2k error 20089 Could not get license information correctly

David Bartosik [MSFT MVP] - 28 Dec 2005 6:33 PM - 4 messages

Having a replication failure on a sql 2k server, logged error is error 20089 Could not get license information correctly I located this in MSDN documentation but no resolution is provided or additional information. Suggestions for trouble-shooting, or a resolution? ...

Multi Language

Peter Cwik - 28 Dec 2005 5:18 PM - 3 messages

Can anyone give insight on the proper way to store names in a multi language database? For instance in English we store First, Middle, Last. In Spanish there could be multiple last names. In Chinese the whole name is only one name, (fits in one field). Any experience with ...

Sql 2000 - Servers not listed

Dave Slinn - 28 Dec 2005 4:27 PM - 7 messages

Over the past week, I have noticed that not all of our SQL server instances are appearing in the various SQL Server lists (such as those in Query Analyzer, ODBC New Connection wizard, etc). We can still connect to the ...

Data integrity error

Cuperman - 28 Dec 2005 4:16 PM - 8 messages

Hi All, This is a wierd one... I have a table for which I wish to remove the IDENTITY attribute for one of the columns. To do this I intended to create a new column, copy the data from the identity column to the new ...

Backing up a database to a remote shared folder

Wingman - 28 Dec 2005 4:16 PM - 6 messages

We are using SQL 2K with sp4 on W2K servers but they are in windows workgroup not domain. The SQL service is started by the local system account. I am having a hard time trying to back up a database to a remote shared folder ...

Please help

Diana M - 28 Dec 2005 3:49 PM - 2 messages

Hello everybody, I have stored procedure that calls number of other stored procedures. If I run stored procedure from query analyzer it never fails. However it fails from VB. And to be more specific, it does not fail, it ...

Restore Collation Change

Joe L - 28 Dec 2005 3:10 PM - 2 messages

Using SQL Server 2005. When I restore a database it changes the collation setting for the new database. I am simply backing up and restoring the DB with a new name to the same server for comparison purposes. The new database has the collation of the server. ...

Server Memory usage\Performance problem

Magnus Österberg - 28 Dec 2005 3:08 PM - 5 messages

I am experiencing the following problem; I boot my Windows 2000 sp#4 machine to get a fresh machine. The hardware is Pentium 4, 3 ghz with 512 mb RAM. There are no other heavy applications running on the machine. ...

Proper indexs against query and optimization

Kay - 28 Dec 2005 2:46 PM - 3 messages

Viewing trace following query gives Duration - 517470 Which indexes should be created on tables and how to make this query optimized. ======================================================= SELECT top 1 package_description.name, package_description.tier, ...

High CPU Usage

Eduardo Sicouret - 28 Dec 2005 2:44 PM - 4 messages

Hello, I need your help urgently. I have a MsSQL server database that behaves normally all day, but at certain times the server's cpu usage rises abnormally. There's no increase in the amount of transactions sent to the server, ...

scheduled backups with the wizard not running"

Joe Hernandez - 28 Dec 2005 2:36 PM - 8 messages

Hello all, I am very new to SQL. We are running SQL 2000. We are using one instance to run Project Web Access and I need to setup a disaster recovery. I have donwloaded the disaster recovery from the project server site. I have a ...

SQL Server 2005 DB errors out as "Could not find stored procedure 'dbo.aspnet_checkschemaversion."

Sharath Shetty - 28 Dec 2005 2:16 PM - 6 messages

Hello All, I get the below mentioned error "Could not find stored procedure 'dbo.aspnet_checkschemaversion'." when I try to access a SQL Server 2005 DB from a .NET application. Anyone has any idea why this error is thrown.. ...

Wich edition run on Win2K Professional?

guinsu - 28 Dec 2005 12:56 PM - 5 messages

Could anyone tell me wich edition of Sql Server 2005 can run on Windows 2000 Professional? Express Edition ? Workgroup Edition ? Developer Edition ? Standard Edition ? Enterprise Edition obviously cannot run on Win 2k Pro. Mobile Edition don't apply in this case. ...

SQL Server 2005 x64 vs 32-bit

Siddhartha Jain - 28 Dec 2005 11:06 AM - 7 messages

Hi, I have two identical IBM x366 servers with four CPUs and four GB RAM each. The two servers are going to be connected to a IBM DS4300 which is a SAN box. I have installed one server with Win2k3 x64 and SQL 2005 x64 ...

read logs

Vaidas Gudas - 28 Dec 2005 10:45 AM - 2 messages

how to know which user was executed the SQL statemant and operations. ...

When to use the db_ddladmin DB role ?

Robert - 28 Dec 2005 6:03 AM - 7 messages

According to the BOL, the db_ddladmin Db role is for adding / dropping objects. I have found that objects in SQL Server 2000 means tables / views / procedures .... In this way, does it mean that database user with db_ddladmin role can read ...

SQL2000 Chinese Character problem

Jason Huang - 28 Dec 2005 5:03 AM - 3 messages

Hi, My SQL2000 is Traditional Chinese version. In most cases, I can INSERT and SELECT correctly. However, there some Chinese words I can INSERT without problem, but the output of the SELECT will be "?", not the word I input to the ...

recover from a sql disaster

alex - 28 Dec 2005 12:01 AM - 10 messages

Is there any good sql 2000 or 2005 disaster recovery plan or guide out that you guys used to come up with your own? What's your procedures do have for backups and for recovery? I asked that because i have been asked to implement a sql server to run a ...

Issue with Installation SQL 2005

Matt - 27 Dec 2005 10:07 PM - 3 messages

We are running some tests here to evaluate whether to upgrade and switch some of the databases from Oracle to SQL 2005, but running into a major issue. We have a W2003 server where we used to have SQL 2000 running. We upgraded ...

query returning incorrect results on null where clause

new_world_order_piggies - 27 Dec 2005 9:21 PM - 11 messages

I have a table in which I perform a query testing whether a particular column is null. The query is something like: select * from the_table (nolock) where the_tableID is null the rows returned have values (integers) in the "the_tableID" column, in ...

Sql Server 2005: Gotchas / Questions about setting up a 2nd named instance ??

frostbb - 27 Dec 2005 6:43 PM - 9 messages

Greetings! I'm relatively new to Sql Server, please take this into account. We have a named instance of Sql Server 2005 up and running that contains multiple databases (production & development) with tables, indexes, stored procs, imported data, etc. This instance is up and running fine on a ...

Taking databases offline

Terri - 27 Dec 2005 6:23 PM - 2 messages

I have a SQL Server 2000 server where some of the databases have data and transaction files on local drives and some have data and transaction files on a SAN. Maintenance is going to be performed on the SAN. I'd like to ...

saving files in sqlserver

Juan Puebla - 27 Dec 2005 4:45 PM - 2 messages

Hi, I supose this question it's been asked a thousand times: wether to save files in sqlserver or in web server directories for an asp.net application. We are developing an asp.net application were users will share files (up to ...

Error 21774

David Chase - 27 Dec 2005 4:40 PM - 11 messages

When I try to go into the dependencies of a table on my SQL 2k database, I get the following error message (twice) and then it takes me to the dependencies screen. Error 21774: [SQL-DMO] The ID '377104434' was not found in the Views ...

sql link to oracle 10g

jesenko k via SQLMonster.com - 27 Dec 2005 3:47 PM - 9 messages

5 day works, 3 days does not work, 2 days work, 1 day doesnot ...ect...... with error Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace[OLE/DB Provider 'MSDAORA' IDInitialize::Initialize returned 0x80004005: ]. ...

Quad dualcore CPU server - can I use SQL2k5 Standard?

andsm - 27 Dec 2005 3:18 PM - 4 messages

Can I use SQL2k5 Standard Edition for server with 4 dualcore CPUs? Licence said - up to 4 CPUs. Will Standard Edition use all 8 cores? ...

SQL 2005 Dev and SQL Express on the same box ?

Oded Dror - 27 Dec 2005 1:53 PM - 3 messages

Hi there, I'm using Windows XP Pro SP2 and I installed SQL Server 2005 Dev Edition with no problems. I want to install the DotNet SDK 2.0 but It's required SQL Server Express. My question is It is possible to install SQL Express on the same machine ...

DTS and Co Question?

o8o___o8o - 27 Dec 2005 10:39 AM - 2 messages

How can i copy data from one db1 table a to db2 table b? 1) all new data should be inserted 2) all other data should be updated (ID's should be the same in both db-tables) thx, mfg Daniel ...

download SQL Server Accelerator for BI

Andreas - 27 Dec 2005 10:22 AM - 3 messages

hi i need the partition aggregation utility for sql server 2000 i found the link at microsoft but the download seems to be moved [link] any ideas where i can find that tool? ...

Between Clause

SouRa - 27 Dec 2005 10:06 AM - 8 messages

Hai, I have a table with datetime type column. I stored the date with time in this column. Now i want to select the records between 10/01/2005 and 10/31/2005. I used 'select * from tablename where columnname between '10/01/2005' and ...

Database Table Structure Comparison - how to?

toebens - 27 Dec 2005 9:03 AM - 8 messages

Hi, i have a database on our production server and one on our developer server. i have changed some of the tables, added new ones... and so on but i'm not sure what i changed in the past. i want to compare my database on both ...

SQL Server 2005 / 2000 fn_trace_gettable

ksnyder71 - 26 Dec 2005 4:56 PM - 3 messages

I see no documentation stating I cannot open a 2005 tracefile on a 2000 database server using fn_trace_gettable. However, that appears to be the case. Can anybody confirm this to be true? ...

cyclic redundancy check error

laurenq uantrell - 26 Dec 2005 3:43 PM - 8 messages

I have revived a database by replacing the log file, detaching and reattaching. Now I get the following error when running a query against the suspected culprit table: Server: Msg 823, Level 24, State 2, Procedure LocationCountbyCountry, Line 3 I/O error 23(Data error (cyclic redundancy check).) detected during ...

Analysis Server 90, Performance Counters

ipramod - 26 Dec 2005 9:57 AM - 5 messages

Hi, I have installed SQL Server 2005. Now, in the system performance viewer I can see some new performance counters added. But I am not able to see any performance counter related to "Anlysis Server 90". Is "Anlysis Server 90" is the new performance object and how to get ...

Question for Optimizer/Query Engine behaviour

amish - 26 Dec 2005 8:12 AM - 8 messages

In my old company we had a project that we needed to complete urgently.we developed a store proc in initial phase arround 250 lines. Logic was to validate the data and then insert it into different 4 tables according to validation. ...

prepared query or statement

Hassan - 26 Dec 2005 7:21 AM - 3 messages

Whats a prepared query ? How do you generate it ? How is it different from say an adhoc or parameterised query ...

Connecting to SQL Server 2005

imarchenko - 26 Dec 2005 3:16 AM - 5 messages

Hello! I was wondering if I need to install something on the client in order to establish ODBC/OLEDB connection to SQL Server 2005. Currently, I have ADO 2.6 installed. Are there any changes in ODBC/OLEDB drivers for SQL Server ...

Query data is very slow

Vensia - 26 Dec 2005 2:06 AM - 2 messages

Dear all, I have SQL Server 2000 installed at the HO server (Pentium 4, memory 512 Mb). The client side (Pentium 4, memory 256 Mb) connect to the server using leased line 128 Kbps. The distance between HO and client side is 10 miles. ...

Tools to monitor SQL Servers from a PDA

Hassan - 26 Dec 2005 2:01 AM - 3 messages

Are there ways to monitor your SQL server while being on a road ? Even if i have a notebook, are there wireless n/w cards that can pick up signals while on the road ? And if not for the notebook, are there PDAs available that could connect me ...

foreign keys

Jake@rsc - 25 Dec 2005 10:08 PM - 2 messages

Is there an easy way to view table propeties using Enterprise Manager or Query Analyser? I am trying to see the foreign keys in each table and which primary key they relate to. Thanks, ...

SQL Express, No of users

John - 25 Dec 2005 4:08 PM - 2 messages

Hi What is the maximum number of users supported on sql server 2005 express? Thanks Regards ...

Synchronising/replicating access with sql server

John - 25 Dec 2005 3:10 PM - 2 messages

Hi Is there a way to synchronise/replicate an access db with sql server 2000 db, short of writing the code oneself? Thanks Regards ...

SQL Server 2000 suddenly changes from Named Pipes to TCP/IP

Leonid Borisov - 25 Dec 2005 1:38 PM - 11 messages

Hello to all, For no apparent reason, SQL Server 2000 (8.00.760) stopped allowing Named Pipes connections. Existing connections stopped working, and no new connections could be made. During this time, TCP/IP connections, both existing and new, worked fine. ...

Granter does not have GRANT permission

polabear - 25 Dec 2005 2:06 AM - 6 messages

As a contract database application developer I created a SQL database 5 years ago for a single PC use application. We recently upgraded to a multi-user environment and I handed the database to the IT department which installed it ...

Synchronising with remote server

John - 25 Dec 2005 1:01 AM - 2 messages

Hi We have an internal ms access database which we need to synchronise with our website with sql server 2005 backend which is hosted on a public host. My question is; is there a way to keep the two databases synchronised using the ...