|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Asynchrous query
Kevin Burton -
8 Jul 2006 11:25 PM - 6 messages
I have a query that because the database is across the country it takes time to bring a large amount of data to the client executing a command. I was wondering if there was a way to execute an asychronus command? Ideally I ...
About loginid anf userid
Iter -
8 Jul 2006 10:50 PM - 4 messages
Hi guys, I backup a database and restore it to different server. In the diffrent server, after I restore database, the userid has been reserved, but loginid has been lost. I want to creat loginid which should be same as oraginal ...
SQLSERVERAGENT logon as ..
Lolik -
8 Jul 2006 6:28 PM - 5 messages
SQL Server and SQL Server browser both logon as Network service. However when I try to set SQLSERVERAGENT to logon as Network service too, get an error "group not found". Read somewhere that SQLSERVERAGENT should not be run as Local system. ...
SQL Server 2005 Express Version file growth
jehle -
8 Jul 2006 6:13 PM - 4 messages
The limit of DB Size for the Express Versio is 5GByte - know any body if it is the file size or which size it means? Because if I use the file type image and store some images on the database, the file size does'nt grow. ...
Integration Services For Each Loop Question
TomT -
8 Jul 2006 6:13 PM - 9 messages
I'm wondering if this can be done (I've had no luck so far): I would like to loop thru a set of files in a directory, place the file name into a variable, then insert the file name as a record into a table. ...
Problem with an update
Identity -
8 Jul 2006 2:00 PM - 4 messages
Hi, I've a table "Table1" with: ID - Cod - Type - Value - Period 1-COD1-AAA-0-Jan 2-COD2-BBB-0-Feb 3-COD3-AAA-0-Feb 4-COD4-CCC-0-Feb Now I want to UPDATE this records using a Second Table "Table2" ...
how to change "Default language for user" for Instance name? (with regedit or other method?)
Asking -
8 Jul 2006 9:10 AM - 3 messages
Hi all, how to change "Default language for user" for Instance name? (with regedit or other method?) I want to change other language for my default language for user option programaticly (in setup program) Thanx ...
New alternative to OSQL question.
ChrisR -
8 Jul 2006 6:01 AM - 15 messages
SQL2K SP4. New info in 2nd paragraph. Howdy all. I have a daily process that gets a .txt file full of Inserts/ Updates/ Deletes and imports them into a SQL DB every day. I have a Stored Proc that calls a .bat which contains OSQL and runs the .txt file. ...
Linked server - admin vs non-admin windows login
Lolik -
8 Jul 2006 12:59 AM - 18 messages
Two windows logins - one admin and another - non-admin, are both setup in sysadmin roles. Both can create a linked server (e.g. Access .mdb file using Jet OLEDB 4.0). However while ADMIN login CAN successfully execute SELECT queries from this ...
Can multiple updates in a transaction interfere?
jxstern -
8 Jul 2006 12:51 AM - 9 messages
I have some code like: begin transaction update mytable set a = x.a from mytable m inner join xtable x on m.id = x.id where m.a <> x.a update mytable set b = x.b ...
Transactions Per Day
Rick -
8 Jul 2006 12:06 AM - 5 messages
I am trying to determine the total number of transactions per day I am getting against my sql server databases. I have been told to add up the Batch Requeste\sec and the transactions\sec then multiply by 60 then 60 then 24. ...
Backups
Niles -
7 Jul 2006 10:19 PM - 2 messages
I have a database maintenance plan to backup the DB and the transaction log. It is not doing backups any more. I can go and do them manually though. I looked at the event log and noticed an error that has been send several time ...
Daily job runs slow after upgrade to 2005.
Tim Greenwood -
7 Jul 2006 9:07 PM - 6 messages
We have a process that uses XMLSpy to import an xml file of products/pricing daily. We receive this file through an ftp site. This process usually ran in 15-20 min with SQL 2000. It is now running about 2 1/2 hours which is ...
SQL2005 - Does Maintenance job (severl tasks) put a DB as..
SangHunJung -
7 Jul 2006 7:30 PM - 3 messages
Hello, just a few simple question. I would like to know for sure that seveal maintenance tasks put a database to a single user mode to perform the action or not. Please comments out the tasks listed below. I have SQL2005 server ...
Northwind database extra SQL needs
soalvajavab1 -
7 Jul 2006 7:29 PM - 4 messages
I have asked for the following questions and I need your advises. Utilizing the Northwind database suppied with SQL Server, create SQL to solve each of the exercises listed. 1. I want to contact all customers who have received over $1,000 in ...
How to determine licensing mode and number of licenses in SQL 2005
Nieves -
7 Jul 2006 6:46 PM - 2 messages
I'm trying to find out how my SQL 2005 server's licensing is set up. I don't see it in the properties of the server and when I query serverproperties, it says licenseType returns disabled and NumLicenses ...
connectivity problem
Bahman -
7 Jul 2006 6:04 PM - 5 messages
good morning! All was fine until a few hours ago. the sequel was set to windows authentication only. then i realized i needed a sequel user account which i then created. then i tried to switch back to mixed mode to make the account ...
Unused indexes
markrr -
7 Jul 2006 3:46 PM - 6 messages
I have inherited a SQL Server 2000 database. It is obvious why some of the indexes exists. But I'm doubtful that others are needed. Is there any way to know if, when, or how often an index is used? ...
Need help integrating sql server with my site
Shan -
7 Jul 2006 3:24 PM - 2 messages
I have hosting through godaddy.com. I have set up an sql server. I know the database name, host name, and dsn. I need to create a page on my webpage that ask users for their name and email address. I want this ...
Can SQL 2005 be changed to accept case-INSENSITIVE passwords??????
winsysadmin -
7 Jul 2006 3:12 PM - 5 messages
We have a SQL 2000 server that has been migrated to a SQL 2005 server. Now when the users log on to the SQL app a lot of them can't logon. I believe this is due to the SQL passwords being case-insensitve in SQL 2000 ...
primary key vs unique key, and indexing
frederic.nourry -
7 Jul 2006 2:50 PM - 8 messages
Hi, the main question is : are unique constraint indexed automatically or do i have to create an index too? i'm wondering how can i get the best performance from a table that as 3 fields to be unique should i put a primary key on the 3 fields , and sql will index it ...
Disabling triggers with alter table, execute as?
b3nny80y -
7 Jul 2006 2:49 PM - 4 messages
I'm disabling some triggers in SQL Server 2000 with the following command launched from another trigger: ALTER TABLE PM00300 DISABLE TRIGGER insPM00300 I want normal users to be able to run that command. Is there a kind of ...
Total sql server memory with awe enabled
mngong -
7 Jul 2006 2:37 PM - 3 messages
Microsoft Sql Server 2000 sp4 . Windows 2000 Server Enterprise Edition 64 bit Total Memory 36G allocated for sql 30G.(Max memory) 30G is always reserved but how can the actual memory sql server uses be got? Massa Batheli ...
Any way to recover schema (thats it) from a mdf file
Weston Weems -
7 Jul 2006 2:28 PM - 4 messages
Ok, with sqlserver 2005, I've noticed my databases being marked as suspect far more often than sql 2000. Anyway... after futzing around with it for quite some time... I'd made no progress. Now I am at the point where the database wasnt cleanly shutdown, and I ...
Memory Used
meyere -
7 Jul 2006 2:23 PM - 5 messages
We have a Quad 2.8GHz with 32GB of RAM running Win2003 x64 SP1 and SQL Server 2000 Enterprise Edition. BOOT.INI has /PAE switch on and 25GB of RAM is allocated to SQL Server. Question is... ...
SA account
Conmit -
7 Jul 2006 2:01 PM - 3 messages
I've installed my SQl server 2000 and forgot by accident the password of this account. Is there a way for me to retrieve this account back or change it again? Please help !!! ...
Alternative to OSQL?
ChrisR -
7 Jul 2006 1:55 PM - 7 messages
SQL2K SP4 Howdy all. I have a daily process that gets a .txt file full of Inserts/ Updates/ Deletes and imports them into a SQL DB every day. I have a Stored Proc that calls a .bat which contains OSQL and runs the .txt file. Are there ...
job category not visible
VSS -
7 Jul 2006 9:13 AM - 3 messages
I have added one new category using , sp_add_category, but when i open to add new job, category is not available in dropdown of catgory in the new job dialog? ...
Transaction Log's script
José Júlio Duarte -
7 Jul 2006 9:03 AM - 5 messages
Hi Somebody has some script to make this requirement? Transaction Log's When the space that the file of TLOG's for any one of the databases used for the Biztalk to reach a quota of occupation in superior record 80% ...
Hide SQL Server DB
mal hit -
7 Jul 2006 9:02 AM - 3 messages
I would like to know if it's possible to embed a SQL Server 2000/2005 DB within a desktop application so that the end users cannot view the DB. Also, this will prevent them from copying the database on to their other ...
Database script to alarm
José Júlio Duarte -
7 Jul 2006 9:01 AM - 7 messages
Hi, Somebody has some script to make this requirement? Databases When the space that the file of any one of the databases used for the Biztalk to reach a quota of occupation in superior record 80% of its maximum size. ...
Getting binary text out of a database using SQL
davconts -
7 Jul 2006 2:55 AM - 3 messages
Hi everyone, Is there a way to return the COMPLETE contents of a binary field with an SQL statement? I've seen one SQL statement in the past, but it only returns the first 200 or so characters. Anyone got a link (or know) how to return the whole lot? ...
sqlmangr - Command Switches?
News Group -
7 Jul 2006 2:28 AM - 3 messages
Hi, Does anyone know if there is a list of command switches available for SQL Server Service Manager sqlmangr.exe? Thanks Colin ...
About lost sa password when rebuild master database
Iter -
7 Jul 2006 2:16 AM - 3 messages
Hi Guys, I rebuild master database in order to change collation setting, but I lost sa password After rebuild. I couldn't logon into database with sa. Why is it like this, can I re-get sa password? Thanks. ...
DB Library error: Login incorrect
Joe K. -
6 Jul 2006 11:00 PM - 2 messages
I have application that I received the error listed below from SQL Server 2000 database. Please help me resolve this error message. Thank You, Error source: dbopen DB Library error: Login incorrect SQL Server message: Login Failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. ...
Account Lockout on SQL2005
Kurlan -
6 Jul 2006 9:09 PM - 8 messages
Hi Champs, Is there a way to recover from a account lockout in SQL2005? I cannot connect to "Database Engine" in "SQL Server Management Studio", error: login failed...18456. And I also cannot start the "SQL Server agent service" Any possebility to recover without reinstall? ...
Bulk Insert Data creating a table first?
bluefish -
6 Jul 2006 8:44 PM - 2 messages
Hi, Is there any way that you can bulk insert/BCP data into a new table without creating a table first. Thank you in advance for your help! Sam ...
backups...
vncntj -
6 Jul 2006 8:27 PM - 4 messages
Hello all I have this T-SQL string. Use master Exec sp_addumpdevice 'disk', 'dbEvents_backup', '\\pmafiles\X$\SQL\TMS\dbEvents\eventsbackup' Backup Database dbEvents to dbEvents_backup Exec sp_dropdevice 'dbEvents_backup' I have two questions When the backup runs it isn't writing over the existing backup. It ...
SQL 2005 Date Variable passed to a Stored Procedure
riley.derrick -
6 Jul 2006 8:11 PM - 2 messages
Bio: Just learning SQL and its greatness, signed up for a few classes. Reading books when I can. Quick Question: I am trying to setup a Stored Procedure that takes in 2 dates. Beginning and End Dates and passing these 2 dates to a Stored ...
Which edition of SQL Server 2005 do I have?
eva.monsen -
6 Jul 2006 7:36 PM - 4 messages
I installed SQL Server from an MSDN disc a while back, but I can't remember which edition I installed (looks like we have Developer and Enterprise discs). Is there any way I can find out? None of the About ...
Connection fails for SQL Server 2005
Chris Jones -
6 Jul 2006 7:31 PM - 5 messages
I have SQLServer2k5 on a WinXP Pro PC. I am having extraordinary difficulty in getting any of the instances to start. Within Computer Management, the SQL Server Configuration Manager reports "Cannot connect to WMI provider. You do not have permission or the server is unreachable. etc, etc. Access is ...
SQL server maintenece plan fails on delete TRN..
gstar -
6 Jul 2006 7:11 PM - 4 messages
Hi, We have a maintenece plan that backs up the MDFs each evening at 02:00, then the transactional logs on the hour from 09:00 until 19:00 each day. The full backup works a treat, & the transactional logs backup ...
Detecting SQL Server 2000 vs 2005 instance
ANeelima -
6 Jul 2006 6:43 PM - 14 messages
I have the following two questions: 1) I can use the ListAvailableSQLServers methods in SQL-DMO to get a list of all the available sql servers (in the form of Namelist) but how can I detect which ones are SQL Server 2000/MSDE 2000 instances and which ones are 2005 ...
Change database
John -
6 Jul 2006 6:42 PM - 4 messages
if you have a database in access, isn't there some easy way to convert it into SQL server like an import or similar? ...
Convert ADP to MDB
jyesbrown -
6 Jul 2006 6:35 PM - 5 messages
My company uses Microsoft ADP to manage and display data. I am the Business Analyst for the division, my manager has asked me to import the ADP and convert it to MDB, so that we can modify queries to generate more reports. ...
TimeOut Expired in VBA and SQLServer
zachi.fernaldes -
6 Jul 2006 4:00 PM - 2 messages
Hi, I'm realy need help, I'm trying executing a StoredProcedure from an Excel VBA. I created a connection to the DB: Const conString= "Provider=SQLOLEDB.1;ConnectTimeout=0;CommandTimeout=0;User ID=xxx;password=xxx;" & "Initial Catalog=DBname;Data Source = ...
SQL Server 2000 EE 64 bit
DXC -
6 Jul 2006 3:32 PM - 5 messages
Is SQL Server 2000 EE 64 bit supported on "AMD Opteron (tm) processor 852" processor or it has to be an "Itanium" processor on Windows 2003?. Is there a 64 bit edition of SQL Server that is supported on the AMD.....processor ? ...
2000 AND 2005 STANARD EDITION ON SAME MACHINE ?
scott -
6 Jul 2006 3:12 PM - 4 messages
CAN I ADD 2000 AND 2005 STANARD EDITION ON SAME MACHINE ? I.E DIFFERENT INSTANCE ...
pad index and fill factor
Loren Z -
6 Jul 2006 3:08 PM - 4 messages
We have a new database set up on MS SQL Server 2005. It was noticed that the pad index has not been set and I have been asked to look into what is a recommended value. What is the rule of thumb when setting the pad index and fill factor for ...
SQL performance monitors not accessible via remote.
Matthew -
6 Jul 2006 2:51 PM - 4 messages
I set up a SQL 2000 Server on a W2K3 system about a month ago. For some reason I am not able to access the SQL performance monitors via a remote system. However they do show in if I run Perfmon on the local ...
SQL2005 Ghost Linked Server?
barkey -
6 Jul 2006 2:30 PM - 4 messages
I DID have a linked server ("Server02") on my new SQL2005 box. Now after removing it, the code attached generates the error below, when there is no reason for it too.. There are no triggers, no linked servers, no other code.. ...
CSV output sql server 2000
Katie -
6 Jul 2006 2:02 PM - 5 messages
Hi, I have a bunch of stored procedures (some using temp tables) which give out tables which are then used in crystal to give out reports. These stored procs are run dynamically depending on values users select on forms Some people instead of reports want Comma Seperated Files (CSVs). I am ...
SQL server 2000 views
rzachary.work -
6 Jul 2006 1:59 PM - 2 messages
I am copying a database that has multiple tables and views, i was wondering why my views are copying over as tables in the database i am copying to. Thanks ...
Linked Server to IBM AS400
Pasquale -
6 Jul 2006 1:56 PM - 3 messages
I need to create a linked server to communicate with an AS400 server by using Client Access ODBC and then launch some query on particular files (inside libraries). How can I solve this issue? I haven't founded any documentation about this subject. ...
Geocoding in SQL Server 2000 DTS Package
stabbert -
6 Jul 2006 1:16 PM - 5 messages
Anyone have any examples or information on how to best accomplish geocoding in a SQL Server 2000 DTS package? Spencer ...
Import from access db to sql express db
reidarT -
6 Jul 2006 12:30 PM - 2 messages
How do I import tables from an access db to sql Express? reidarT ...
Full text or not full text?
pinhead -
6 Jul 2006 12:03 PM - 5 messages
I have problem with the speed of queries. I'm searching for UK car number (registration) plates consisting of 2 letters, followed by 2 numbers, followed by 3 letters. ie; AB12CDE or maybe UV98XYZ - examples ONLY to show type of data. ...
Log shipping error
VSS -
6 Jul 2006 11:24 AM - 3 messages
I m getting following error in copy/restore operation "The process cannot access the file because it is being used by another process." This come against the file first_file_000000000000.trn every time copy restore is done. Only first time it went successful. Error number is 32. ...
Log Grow
CC -
6 Jul 2006 10:26 AM - 2 messages
Hi, Simple question but, for me, not obvious. SQL Server 2000 + SP4. My tempdb has 3GB, the Tlog for tempdb is growing and it has now 37 GB. Recovery model simple. 1º Question - Why is growing the tlog for tempdb ??? ...
Login failed for user 'sa'
AlanF -
6 Jul 2006 10:01 AM - 3 messages
When I try to access my SQL database via the SQL Entrerprise Manager, I get the following error message: ----------------------------------------------------- A connection could not be established to machine_name\database_name Reason:login failed for use 'sa' Please verify SQL server is running and check your SQL server registration ...
Error read data from Sybase with SSIS 2005
Sal -
6 Jul 2006 8:51 AM - 3 messages
Hi to All, I am in process of transfering data from Sybase to Sql Server using Microsoft Visual Studio 2005 have taken a Data Flow Task in Control Flow tab In Data flow tab, I have taken one Ole DB Source ...
time interval related sql query
raju -
6 Jul 2006 8:30 AM - 7 messages
Hello, I need a sql query for this situation. I working in an application using sql mobile edition. I that i am having one table called "shifttime", that contains the columns, ...
Passing a variable to a job
saulmarg -
6 Jul 2006 6:52 AM - 6 messages
Is it possible to pass a global variable to a SQL Server 2000 job? Or is there another solution that I can use - I don't want to store what I'm passing through as plain text. Thanks, Saul ...
Collation Problem on Sql Server 2000
ss -
6 Jul 2006 5:30 AM - 2 messages
Hi all, My database's collation setting is Turkish_CI_AS and I need to change as SQL_Latin_General_CP1_CI_AS which I use command for this operation as follows "Alter Database [ORDER] collate SQL_Latin_General_CP1_CI_AS" but I have error message like that : Server: Msg 5030, Level 16, State 2, Line 1 ...
SQL Express - Import Data from a Deliminated TextFile
Stephan -
6 Jul 2006 1:51 AM - 3 messages
Hi there! I am new to SQL 2005, but I have experienced the SQL 2000 for quite awhile. Currently, I have installed the SQL Express for self testing, however, I could not find the functionality of importing data inside the server. ...
Query plan
KTN -
6 Jul 2006 12:08 AM - 2 messages
I have 2 SQL Servers with same hardware, configuration and database layout, but the query plans are different on each server. I tried to look on BOL and websites and have not find an aswer to why they are different even though ...
DTS import from excel - odd decimal scale
nethervoid -
5 Jul 2006 11:52 PM - 4 messages
I have a DTS package with which I'm trying to upload values from excel. One of the columns contain a set of numbers with max of 6 digits total and 3 digits to the right of the decimal. My corresponding column in ...
How to connect to the SQl server EXPRESS using 'ODBC Data Source A
sanjib -
5 Jul 2006 11:37 PM - 11 messages
Hi All, Recently I have installed SQl server express edition. I was able to connect to the SQL server from my .NET project using connection parameter like: Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\Raju\My Documents\Sanjib SQL DBs\IBuyAdventure\IBuyAdventure.mdf;Integrated ...
Database design question - Using Field definition table
sreedhardasi -
5 Jul 2006 11:12 PM - 5 messages
Hi, We have a table similar to the following schema. Product table product_id int, product_name varchar(50), product_desc varchar(100), product_price money, product_sub_category_id int We also have tables for product category and sub category. We would ...
Connection count gone wild after upgrade to SQL2k5!!!
Tim Greenwood -
5 Jul 2006 10:33 PM - 4 messages
We upgraded our server last week to SQL 2005. Prior to this on SQL2k we averaged 100 connections to the server from our web servers and in-house applications. All we did was update our application config files so the ...
q: duplicated rows
JIM.H. -
5 Jul 2006 9:58 PM - 4 messages
Hello, I have a table T1 with fields ID, F1, F2, F3, F4, F5, F6…. I need to find if there is duplicated rows based on F1, F2, F3 columns. If there is set F5=’minimum’ where ID is MIN(ID). So the smallest should be set ...
SQL 2005 Max Memory Setting..
BATMAN -
5 Jul 2006 8:51 PM - 3 messages
Is there any reason why in SQL 2005 the Max Memory is set to 2147483647 out of the box? On boxes with only 4gb, should this value be changed? ...
CHECKDB and Object ID 0
Dave -
5 Jul 2006 8:37 PM - 5 messages
Can someone please tell me what "Object ID 0" is? It does not exist in sysobjects and I can find a reference in BOL or in the groups/forums... I am trying to anlyze the first line returned from DBCC CHECKDB ...
[Microsoft][ODBC SQL Server Driver]Timeout expired
bajaj.vishal -
5 Jul 2006 8:32 PM - 2 messages
Hi all !! I get the error: "[Microsoft][ODBC SQL Server Driver]Timeout expired" when I run a delete statement for a table to delete records which run into 100s. The SQL is 2000 enterprise edition SP4 on a win 2000 server. ...
When is it ok to Shrink a Database?
Jayme -
5 Jul 2006 8:08 PM - 2 messages
Just curious if it is necessary to ever shrink a database? (if there is always enough disk space). ...
SQL 2005 and Windows Authentication
cav -
5 Jul 2006 7:31 PM - 3 messages
I have installed MS SQL 2005 and have selected windows authentication. When I installed the program I was logged in as administrator. As a general rule, I rename the administrator account before installing software however I did not do it this time. When I launch the SQL Management Studio, the users name ...
Query Help re: Duplicates (of sorts)
Carl -
5 Jul 2006 6:21 PM - 9 messages
I couldn't find a group that seemed to be better suited to query help and the only query-centric group I found was for Access. So, any help in finding the right group (if one exists) would be greatly appreciated. ...
Restore MASTER
Rowan Prior -
5 Jul 2006 6:12 PM - 2 messages
Hi there, My RAID data drive failed, and I need to restore the MASTER DB. When I put the server into single user mode (sqlservr -m ) and launch Enterprise Manager, or Query Analyzer, I can't log into to perform the ...
64bit vs 32bit
Sean -
5 Jul 2006 6:10 PM - 3 messages
If I create a database on 64bit version of SQL 2005 and then copy it to a 32bit version SQL 2005 will that database still work? and/or will adminstrators have to make setting changes? ...
Dump of SQL permissions?
ChrisR -
5 Jul 2006 6:06 PM - 2 messages
SQL2K sp4 Is there a way to get a list of all assigned permissions in a DB? I'd like to see it in a format like this: Database X Object Name Roles Users ...
Msft Access, SQL Server support for Volume ShadowCopy Service (VSS)
Ken L -
5 Jul 2006 5:55 PM - 2 messages
Can anyone point me at some reference material on Microsoft Access' support for the Volume ShadowCopy Service in WinXP Pro and Win2003 Server, please? I am particularly interested in any information on backup of open databases and whether the standard Microsoft OS software-based snapshot copy support ...
Need help performance tuning a query on a VLDB
Rich -
5 Jul 2006 4:44 PM - 4 messages
Hi everyone, I am running the following query three times for a particular report, using different date ranges. The query executes in about 6-17 seconds seconds... because it's run three times, this can add as much as 51 ...
SQL time out
bajaj.vishal -
5 Jul 2006 4:42 PM - 4 messages
I have a server running Win 2000 with SQl 2000 Enterprise edition SP4. The server also hosts the web application in ASP. The application is very copmplex and involves a lot of complex queries to the database. At peak usage time the users get a "Page cannot be displayed" even though ...
NTFS Juntion Points and SQLServer 2000 SP4 on W2K3 SP1
Greg Pagan -
5 Jul 2006 3:35 PM - 5 messages
Is there any reason not to use NTFS juntion points with SQLServer 2000 SP4 on Windows Server 2003 SP1? What I am considering doing to expand the amount of space available to one of my instances is moving it to a mount point that is on some new disks. ...
Lite speed 2005 on 64 bit OS
DXC -
5 Jul 2006 3:14 PM - 2 messages
We have 64 bit OS / 32 bit SQL-Server on a Windows 2003 server. Lite speed 2005 doesn't seems to work on it. Is this setting supported by Lite speed 2005 ?. I know it is NOT a good idea to have 32 bit SQL Server 2000 on 64 bit ...
SP_HELP not returning column descriptions
mark.norgate@gmail.com -
5 Jul 2006 2:46 PM - 5 messages
Hi I'm using SP_HELP to retrieve information about a particular table in my SQL 2000 database. Unfortunately, this procedure doesn't return the "Description" of the columns, as seen when you design the table. I can't find these ...
Calling another .sql file from an existing .sql file
ANeelima -
5 Jul 2006 2:36 PM - 8 messages
I have a vb application that executes a .sql file called "fileA.sql" using the osql cmd. I would like to know how to make fileA.sql call fileB.sql. In an oracle based .sql file, I generally would call fileB.sql from within ...
Copy/Paste fails in SQL Server Management Studio
Dave Sundell -
5 Jul 2006 2:35 PM - 8 messages
Has anyone experience the much frustrated situation of having the copy/paste functionality fail within the Management Studio query editor environment? I will be working fine, doing copy/paste within the query editor and then for some reason the "copy" quits. I can copy from an outside source, e.g. ...
Starting SQL Server Service
RM -
5 Jul 2006 2:29 PM - 4 messages
Hello All, I'm having trouble starting the my SQL server database engine on the Local machine I'm currently running it from. I get the follwing pop-up error message and need some help in getting this started again. ...
How to DROP DEFAULT constraint?
Meade Swenson -
5 Jul 2006 2:11 PM - 5 messages
We initially created a table (SQL Server 2000) having a column with a DEFAULT value of 0. We want to drop the column, but we cannot until the DEFAULT constraint is removed. Documentation indicates we should be able to ...
need programmer to build a DTS...
dan -
5 Jul 2006 2:00 PM - 2 messages
I need to get a dts package built in sql 2000. Basic tasks are: * Users login to site and upload excel files to their own directory * Need to validate the data within the excel files * Then import that data into an existing database ...
Can You Execute .SQL or Stored Procedures via Batch Files? Examples?
gary -
5 Jul 2006 12:14 PM - 5 messages
Am currently executing DTS packages via DOS Batch Files (using the DTSRUN command) and use Windows Scheduler to run them (sample code below). But now I need to execute either ..SQL query files or Stored Procedures via Batch Files as ...
Database reorganization
mripplinger74 -
5 Jul 2006 12:03 PM - 13 messages
Database reorganization We use SQL 2000 and our application database is around 2 Gb. A third party consultant (Microsoft Certified) counseled us to perform database reorganization, at least once each year. The way he recommend us to execute the database reorganization is the ...
SQL2000 Merge Replication Error
hjh -
5 Jul 2006 11:49 AM - 3 messages
I have been using SQL 2000 with merge replication successfully. ( I do not use scripts to set it up but only the graphical user interface of Enterprise manager). Recently one of my tables needed to change the primary key from 2 fields to 3 fields. So I stopped the replication and ...
Trouble saving large amount of text to database
Diana -
5 Jul 2006 11:36 AM - 7 messages
I'm finding it very difficult to save large amounts of text to my SQL Server. This happends either I cut and paste it directly into the column or if I try to insert it thrue a asp-form. The data type I've chosen for the column is ntext (value 16), but still it ...
SQL2K5 Mirriring conceptual question
Ido friedman -
5 Jul 2006 11:27 AM - 9 messages
In all overviews of DB mirroring it says that the client enjoys transparent redirection when a failover from the principal to the mirror server occurs. After installing and playing with this feature I cannot understand the concept of transparency, how is this accomplished? ...
Cannot resolve the collation conflict
Pedro -
5 Jul 2006 10:34 AM - 9 messages
Hi all, I have this problem in my SQL 2K5 Server Cannot resolve the collation conflict between "SQL_Latin1_General_CP1250_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. I can't solve this problem. I already try to change the data bases collation, to Modern_spanish_CI_AS, but don´t solve my problem, but doesn't ...
SQL Data Files
Gav -
5 Jul 2006 9:42 AM - 5 messages
I have a 288GB SAP database which currently consists of 3 96GB data files. All three of these are on the same LUN which is RAID 10. Is there any performance benefit to having more smaller datafiles, for instance 6 48GB ...
Database Size and SP4
Robert -
5 Jul 2006 9:07 AM - 7 messages
As far as I know, the database size contains both Index and actual data. Is there any command to find out the exact space occupied used by Index and Data ? The SQL Server 2000 Database is of 5GB allocated with data (I think ...
Upgrading SQL server
Simon -
5 Jul 2006 8:58 AM - 6 messages
My company is moving from 180 individual SQL servers to a citrx environment. The SQL server in the new environment that has been recommended to us seems under powered to me. We would have 180 databases sitting on the new servers, with 1200 users and ...
System.Data.SqlClient.SqlException: Arithmetic overflow error converting expression to data type tin
Next »
|
|||||||||||||||||||||||