|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Disaster Recovery Site Setup
DKRReddy -
19 Aug 2006 5:25 PM - 3 messages
All, We are planning to setup disaster recovery in Vegas, actual one is in SanFrancisco. We have to synchronize the databases from SanFrancisco to Vegas.Ours is 24 X 7 ecommerce site. ...
Filtering Data in FROM section vs WHERE/Does it Matter?
gary -
19 Aug 2006 4:27 PM - 3 messages
Using SQL Server 2000. Does it matter whether you apply "filtering" in the FROM section vs. the WHERE section in a case like this? The only difference is the first example uses the DATE filter in the FROM section. The 2nd example ...
mirror access
anightintheparishilton -
18 Aug 2006 11:35 PM - 2 messages
Can you access a database mirror via sql while it is being mirrored to, not after failover? ...
top function in sql server 2005
arale888 -
18 Aug 2006 10:54 PM - 3 messages
Hi: I want to have a dynamic top function that return me different number of rows based on a variable. For example, I have two tables. One has the region name and the row count that I need. Another one is the table that has student ...
Importing date w/SQLExpress appends '.000' to field
Dale -
18 Aug 2006 10:39 PM - 3 messages
Hello I have a DOB field in text file I am importing into an SQLExpress database with the field data type is set to 'datetime'. For some reason the date imports as 1958-08-01 00:00:00.000 ( with a decimal and 3 zeros appended to ...
SQL server user logins audit
Kumar -
18 Aug 2006 9:55 PM - 3 messages
Hi Folks, We have some inhouse applications developed using microsoft technologies like C#.net,asp.net and sql server 2000. All our applications end users are sql users in that sqlserver with their windows domain credentials. Recently Sarbanes-Oxley Audit conducted in our company. ...
Stored Procedure Optional Parameters
Isaac Alexander -
18 Aug 2006 9:38 PM - 5 messages
I am using MS SQL Server 2005. I want to create a stored procedure that has optional parameters meaning they can be null sometimes. Example simple test sql (only select stmt would be in proc): declare @Last varchar(30); ...
Many databases on one or multiple SQL2000 servers
John J. Berlo -
18 Aug 2006 7:51 PM - 3 messages
Hi there. We currently have an application which requires separate databases for each "project" we work on. We are in the process of replacing our 2 SQL 2000 servers and are unsure whether to purchase 1 or 2 servers. Previously, ...
MDF older than LDF
Tim Camp -
18 Aug 2006 7:50 PM - 3 messages
One of my servers was running slow this morning so I got a call. I started looking around and saw that my MDF was almost 2 months older than my LDF on the main database for the slow application. I am running W2K3 SBS with SQL ...
tempdb
coenzyme -
18 Aug 2006 5:46 PM - 2 messages
The SQLlog is indicating the following error: "Autogrow of file 'templog' in database 'tempdb' cancelled or timed out after 15 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size." and "The log file for database 'tempdb' is full. Back up the transaction log for ...
SQL Service Advertising problem
badazizi -
18 Aug 2006 4:43 PM - 2 messages
I have placed a SQL server on a DMZ that is on my internal network. I understand that as a Windows system starts, it advertises its services through Service Advertising Protocol, which allows client computers to browse and select servers of a particular type (in my case SQL Servers). Is this ...
Orphan Userid Restore Database
Joe K. -
18 Aug 2006 4:33 PM - 4 messages
I am looking for the program that you need run after you restoring a SQL Server database that will correct orphan userid within the database. Thanks, ...
changed listening port - cant connect Mangement Studio ?
scott -
18 Aug 2006 4:32 PM - 3 messages
Hi, I have "SQL 2005 express edition" running on 2003 standard (R2). I used the "SQL Server Configuration Manager" to changed the listening port from 1433 to 1722. I do this by following these instructions: [link] ...
Filegroup with no file, not possible to remove it!
Jeremy Calles -
18 Aug 2006 2:51 PM - 12 messages
Hi All, I have a problem with one of my filegroup. Every files have been removed, but when I try to remove the filegroup, I have the following error: Msg 5042, Level 16, State 8, Line 1 The filegroup 'TEXT' cannot be removed because it is not empty. ...
Automatically copying tables to a backup question...
almurph -
18 Aug 2006 2:19 PM - 3 messages
Folks, Hope you can help with this one please. I want to regulary copy the contents of a particular table in a database to another database server with an identical setup. My question is: does SQL Server 2000 have the ability to do this ...
Win2K ODBC with SQL2005
Brian VanDyke -
18 Aug 2006 2:03 PM - 3 messages
I am attempting to setup an ODBC connection on a Windows 2000 workstation to a SQL2005 database. When I setup the ODBC, I get the following error... However, this DLL works fine for SQL2000 databases, and I do not have this ...
SQL2000 Job Ownership
WANNABE -
18 Aug 2006 1:25 PM - 3 messages
I am assuming that all jobs are run under the SQL services login ID, and would use those access rights. But if that's so, what is the purpose of the Owner: field on the job?? Thanks ...
Emailing from the SQL 2000 server
Jordan -
18 Aug 2006 12:05 PM - 4 messages
I have a few maintenance routines created and SQL 2000 has options to email the reports. Do I need to have Outlook installed on the SQL server to do these emails. Also, since outlook uses user profiles I assume that I must log onto the SQL ...
Multi server administration broken in SQL Server 2005
Marc Mertens -
18 Aug 2006 12:00 PM - 2 messages
Hello, When I try to setup multiserver administration for SQL Server I always get the error 'The enlist operation failed (reason: SQLServerAgent Error: Unable to connect to MSX 'my master server name') (Microsoft SQL Server, Error 22026). I have a fresh installation of the ...
Drive Dying - how to rescue SQL
tony -
18 Aug 2006 9:54 AM - 4 messages
Hi All, I have sql 2000 on Win 2003. I think my drive is dying (once I got in to work and machine was dead and drive check showed a lot of errors) Anyways, now I am having problems backup up certain SQL db's (in order to ...
How to decrease the size of Dat File?
Jaison Jose -
18 Aug 2006 9:51 AM - 2 messages
Hi all, I am having a database which is having 10GB allocated space for the data file. But actually the currently used space is only 1GB.I just want to decrease the size of datafile from 10GB to 5GB. For achieving this i have ...
shrink file to a high OLTP DB
Hassan -
18 Aug 2006 5:45 AM - 4 messages
Will it cause any slowness to the stored procs while the shrink is going on ? Will it hold some locks ? ...
SQL Server 2000 and SQL Server 2005 on Virtual Servers
Andrew Hayes -
18 Aug 2006 1:49 AM - 5 messages
We have 2 web applications. One uses SQL Server 2000 for the DB, while the other uses SQL Server 2005. Rather than have 2 seperate servers to supply redundancy in the form of replciation, can we use a single server running 2 ...
SQL Server 2000 - sql server user account loses database permissio
Joe K. -
18 Aug 2006 1:08 AM - 2 messages
I have a sql server user account that periodical loses permission to groups and db_datareader access to several databases. What is easy way to determine the process or stored procedure that is changing the permission on this sql server user account. I would to complete this task without using the SQL ...
How to exec a SQL in stored procedure?
Cylix -
18 Aug 2006 12:54 AM - 3 messages
For example, I have a variable @SQL = 'Select ''Hello World''' How can I execute this @SQL in stored procedure? Sorry for newbie question =] Thank you. ...
SQL Server 2000 Performance on Windows x64
David -
18 Aug 2006 12:49 AM - 2 messages
Hi All As SQL Server 2000 is only 32-bit (except for the Itanium edition) will SQL Server 2000 suffer any performance degradation as a result of being installed on Windows Server 2003 R2 Standard x64 Edition? Thanks ...
Query Timeout
cbrichards via SQLMonster.com -
17 Aug 2006 9:11 PM - 10 messages
I have a rather complicated query statement in a stored proc which all of a sudden hangs in production. I copy the same database to QA and run the stored proc and it executes in less than a second. The explain plans are different ...
Registration of SQL Servers missing in Enterprise manager
VM -
17 Aug 2006 8:39 PM - 6 messages
Hi All, Recently a strange behaviour was seen with Enterprise manager. When we change the Windows login password all the registrations of SQL Servers are missing from SQL Server Enterprise Manager. Did anyone faced this situation before? Its really painful to register 20 servers each time when login ...
PLEASE HELP with query
Michael Kintner -
17 Aug 2006 7:43 PM - 3 messages
I am trying to use a IN statement Select * From ShowMenusFirst WHERE (Security In ((select Security from Users Where (Username='mkintner')))) ORDER BY Menus.Level; The results from the query select Security from Users Where (Username='mkintner') is 'Low','Med' ...
FYI> "Invalid command option D." >Resolved
WANNABE -
17 Aug 2006 6:37 PM - 2 messages
Just thought I would pass this along in hopes that it can help someone. When I had changed the startup parameters for SQL so that the databases and log files would be in different locations. I used CAPITAL LETTERS to ...
SP4 queries lasting 10 times more
Luis Fernández -
17 Aug 2006 6:26 PM - 2 messages
Hi, We've got some staging and fact table loading processes for our BI datawarehouse wich launch heavy queries. After applying SP4, some of these queries/processes perform until 10 times worst, and are "apparently" self-blocking in the SQL Server activity snapshot. ...
Error when executing a distributed query on a linked server
SammyBar -
17 Aug 2006 4:57 PM - 2 messages
Hi, It's a repost of an old thread with more information included I'm testing a Sql Server 2005 Enterprise Evaluation Edition 64 bits. I've been trying to link a sql server 2000 SP4 to this but I'm having some ...
Can I use .DNF file to recover my data?
Mike Torry -
17 Aug 2006 4:50 PM - 3 messages
I want to recover data in a table on SQL 2000 server. This database has 10 files (.MDF, NDF, and LDF). I know which .NDF file contains the data of the table. I made detach the database. Can I use one old backed up .NDF file replace the current .NDF file, and ...
if statements
Ben Watts -
17 Aug 2006 4:39 PM - 6 messages
Where do I put the if statements. do I put them after select or after from or after where. Or in one of those areas. Not sure, never used one before. ...
.NET assembly
Julio Delgado -
17 Aug 2006 3:19 PM - 2 messages
Can I reference a .NET assembly in MS-SQL 2005 Workgroup like we do with COM objects Thanks ...
TempDB Clarification
cbrichards via SQLMonster.com -
17 Aug 2006 3:15 PM - 5 messages
Can you please confirm my understanding of TempDB: 1. TempDB is in Simple recovery and therefore the TempDB log (.ldf) is primarily used for rollback purposes. 2. The TempDB datafile (.mdf) is where temporary tables, temporary stored procedures and worktables are built. ...
Upgrading to Sql 2005
Denis Desjardins -
17 Aug 2006 3:11 PM - 8 messages
Hi everyone, I need your expertise to find the best way to do the following: - I have a datawarehouse in Sql 2000 (over 200 Gb of data) with many Dts (over 75) running daily via a Sql Server Job to load different data sources. ...
DBCC DBReindex on NonClustered
cbrichards via SQLMonster.com -
17 Aug 2006 3:05 PM - 5 messages
If I execute the following statement on a nonclustered index there is no reduction in fragmentation on the index: DBCC DBREINDEX ('DBName.dbo.MyTable','IDX_MyTable_NonClustered',0) WITH NO_INFOMSGS The table on which I am performing the above statement has a clustered index. ...
Can SQL2000 notify me if a new job or DTS is created ?
WANNABE -
17 Aug 2006 2:35 PM - 3 messages
Hi, ya-all. That's basically my question in a nut shell. Can it, and How do I set it to ? Thanks. ...
Network Connects to Wrong SQL Instance
Jonno -
17 Aug 2006 2:35 PM - 3 messages
I have a server running Windows Server 2003 with two instances of SQL Server 2000 - a default instance and a named instance I shall call "INSTANCE_A". Locally, SQL Server works correctly. Query Analyzer connects to both instances (SERVER and SERVER\INSTANCE_A) correctly. However, over the ...
Create cursor from stored procedure
Mark Miller -
17 Aug 2006 2:29 PM - 3 messages
I have a stored procedure which I want to view the results in a specific sorted order, however I do not have control over the stored procedure as it has been created with the ENCRYPTED keyword. I tried to use the INSERT ...
SNPP from SQL
Julio Delgado -
17 Aug 2006 2:27 PM - 2 messages
Hi, I would like to send a SNPP message if the data I am going to insert on the database meets certain criteria. I notice that there are a couple of vendors with SNPP objects (.NET and COM) I am using MSSQL 2005. The data is ...
Split Database
Terry -
17 Aug 2006 2:25 PM - 3 messages
How can I split a large database in SQL Server 2005 into many parts? ...
syscategories
Rob -
17 Aug 2006 2:18 PM - 2 messages
Hi, Can I safely update the syscategories table without any impacts to any dependencies, if any? I have created a number of similar type jobs and would like them to be categorized so that I can distinguish them easily. TIA. ...
SQL query to find repeat entries
Greg Smith -
17 Aug 2006 2:01 PM - 2 messages
Can you run a query that will return only results that have the data in a target column duplicated in another row? i.e. Duplicate address data Result data: RecordID Lastname Firstname Address ...
Where Can I find the Manager Tool for SQL Server Express
Bob Hanson -
17 Aug 2006 1:57 PM - 4 messages
Hello All, The last time I needed it, there was a CTP for the new SQL Server 2005 Express Manage. Can someone let me know where to find it now? Thanks for your help :) ...
How to Run SQL Profiler with non-admin users
Eco -
17 Aug 2006 9:42 AM - 7 messages
A user needs to run SQL Profiler, how can enable him to run this tool without assign admin rights? or Any alternative way? Thanks. ...
Charset&collation
William Stokes -
17 Aug 2006 7:51 AM - 8 messages
Hello, How can I find out from SQL SRV2000 which characterset and collation is used. Thanks -Will ...
Identifying Table scans and Index scans
Karthik -
17 Aug 2006 7:03 AM - 7 messages
Hi, Is it possible to examine which queries are performing table scans and which ones are doing an index scan without going through the execution plans? I am asking this because, I have been given a few databases by my manager ...
What is sp_prepexec?
Cylix -
17 Aug 2006 2:53 AM - 2 messages
I found I have a lot of process to run this process, but I don't know whats that. Thank you. ...
Cannot generate SSPI context
Anatoli -
17 Aug 2006 2:30 AM - 5 messages
Hi, Im having trouble connecting to the SQL2005 default instance installed on one of my sql servers within my domain. I have a second SQL2005 server that I can connect to just fine. Both are in the same OU. This particular server, I can connect to AS2005, but not to SQL2005. I keep ...
How to copy database in SQL server 2000?
Ivan -
17 Aug 2006 2:01 AM - 3 messages
Dear all, I need to copy a database from SQL server A to SQL server B, but the name of database in SQL server B should not be the same as in server A. (Both SQL servers are 2000) Can anyone advise which is the best way to do that? ...
Slowness on multi processor boxes.
ChrisR -
16 Aug 2006 9:36 PM - 10 messages
SQL2K SP4 Howdy all. I have a query with bizarre results in Query Analyzer. Box1; 4 x 3.0 processors, 4 gigs of RAM. Results never come back. Box2; 8 x 3.0 processors, 16 gigs of RAM. Results never come back. ...
Server: Msg 8115
Preacher Man -
16 Aug 2006 8:57 PM - 4 messages
I am experiencing an error message when I run a TSQL and I don't know how to correct it. Server: Msg 8115, Level 16, State 8, Line 38 Arithmetic overflow error converting numeric to data type numeric. In this code I am extracting hierarchical information. I am going 6 levels ...
backup strategy for mirroring servers
Wenbiao Liang -
16 Aug 2006 6:05 PM - 3 messages
Hi guys. We have a DB system that is relatively small and transactions are not very big, but very important, losing data will be very costly to the business. I am assigned to port this system to SQL Server 2005 Sp1, we have decided to ...
MS SQL Srv 2000 and extended stored procedures
Chris -
16 Aug 2006 5:51 PM - 7 messages
hi, I have created my own dll file that I would like to use in sql 2000 as an extended stored procedure. I have checked the dll is written correctly (I can use it in other application). The dll file is created in C# (Visual Studio ...
rows column in sysindexes table got overflow
hm100 -
16 Aug 2006 5:46 PM - 3 messages
Hi, does anyone have the overflow issue with the column, rows in the sysindexes table? We have table with over 3 billions records and it throws error 8115 overflow error when I double click the table, which should return row counts in the table. There is no issue with all data manipulation on this ...
Help with Sort ID differences
Joe D -
16 Aug 2006 5:40 PM - 3 messages
Hi. I was wondering what is the default differences in the following 2 sort order ids: 51 - SQL_Latin1_General_CP1_CS_AS collation. 71 - Latin1_General_CS_AS collation. As some of you may have guess, the same SQL code returns different results sets from two servers that are nearly the same with the execption being, the ...
SQL Hangs when initializing MSDTC.
GregJPrice -
16 Aug 2006 4:54 PM - 3 messages
Has anyone encountered this behavior? SQL Server Hot Fix Roll-Up package was installed on SQL Server 2000. SQL versions were updated from 8.00.2040 to 8.00.2187 as part of this roll-up package installation. The SQL Server patch installer required a server reboot after the ...
migrate linked servers with passwords
DBA72 -
16 Aug 2006 4:40 PM - 2 messages
This is one that I've seen asked often but without a definitive answer: Is it possible to migrate linked servers including passwords to a different server. I can get this to work on the same server with the script below but I ...
Application Role behaves differently in 2005??
shub -
16 Aug 2006 3:49 PM - 7 messages
Here is a very simple test that I ran on my 2000 and 2005 box and in both cases I got different results. When I ran this command on 2000 it worked fine but when I ran the same script on a 2005 box I got the ...
Stored Procedure IN clause
Isaac Alexander -
16 Aug 2006 3:45 PM - 3 messages
I am using SQL Server 7, 2000 and 2005. I want to create a stored procedure for my query. My query is as follows: select column1, column2, column3, column4 from table where date1 >= 'Jan 1, 2006' and date1 M 'Jan 2, 2006' ...
Data from Access to SQL 2005
WPedersen -
16 Aug 2006 3:08 PM - 4 messages
Hello - I'm trying to migrate data from an Access 2000 database to SQL 2005 Express programatically. Both databases have the same schema. Most primary keys are Auto Increment fields. I'm having the issue that even if I set primary key manually in my code, the Auto Increment rules ...
No Truncate Option in Log Backup
Techhead -
16 Aug 2006 2:55 PM - 17 messages
I need to peform a log backup with no truncate. My regular maintenance plan runs like this: EXECUTE master.dbo.xp_sqlmaint N'-PlanID FB8A5BE6-65F9-498C-8F76-AA324BB6139D -Rpt "G:\Program Files\Microsoft SQL Server\MSSQL\LOG\DATABASE_NAMEDB Maintenance Plan6.txt" -DelTxtRpt ...
Insert with Primary Key fails after first time
Lowe5000 -
16 Aug 2006 2:54 PM - 2 messages
Using AccessXP as Frontend and SQL Server 2005 as backend. Tables are linked via ODBC. Last Known action before error appeared: Deleted all records from linked Tables. I add a record including the PK to a table - no problem. I do it again and get error message because of key violation. ...
Multiple variables to an IN sstatement
pravin.nagarajan -
16 Aug 2006 1:10 PM - 5 messages
How can I pass a list of comma seperated values to an IN statememnt? ie @parameter = '1,2,3,4' select * from table_name where column_name in (@parameter) This can be executed dynamically, but is there any other method? ...
SQLTRACE_BUFFER_FLUSH
Olivier Matrot -
16 Aug 2006 12:18 PM - 10 messages
Hello, After analysing waits in my SQL2005 database, it appears that a lot of time is spent waiting SQL Trace buffer to be flushed. Is there a way to disable SQL Trace counters to improve overall performance ? TIA. ...
First connection fails through Access
dgall -
16 Aug 2006 12:17 PM - 2 messages
I am accessing a linked server through a VPN connection. I am updating through an Access interface. The first time that I perform an update on the linked server table, I get an update on linked table error. The ...
Column description
Vicko -
16 Aug 2006 12:14 PM - 5 messages
Does anybody know where stored column description in sql2K database is? Is it possible to script table with this information. Thanks in advance ...
MMC for SQL Server 2005?
Nina -
16 Aug 2006 11:40 AM - 3 messages
I would like to add SQL Server 2005 management console to my custom built MMC – but the only snap in I can find is SQL Server Configuration Manager. Is there a snap-in for SQL Server 2005 available or do I have to use SQL Server ...
sql 2000 and WMSDE
Support Technique -
16 Aug 2006 9:47 AM - 2 messages
Hi, What is the difference between SQL2000 and WMSDE ? Thanks ...
Different SQL mail
Tony WONG -
16 Aug 2006 9:33 AM - 2 messages
my config is SQL2000, outlook xp now i use xp_sendmail to see email from SQL2k how can i use different mail profiles for different database? or i can control it at script level? i have searched google for this and seems it is feasible. ...
Different SQL mail
Tony WONG -
16 Aug 2006 9:33 AM - 2 messages
my config is SQL2000, outlook xp now i use xp_sendmail to see email from SQL2k how can i use different mail profiles for different database? or i can control it at script level? i have searched google for this and seems it is feasible. ...
Where are BLOBs stored in an SQL Server 2000
just-a-dane -
16 Aug 2006 9:13 AM - 5 messages
I you create a table containing one or more blob's (image og text fields) where ist the acctual data storet - in the table og "outside" the table ...
How to export/import tables with binary data
andrea favero -
16 Aug 2006 9:08 AM - 5 messages
We need to export tables with binary data and then import them into an "isolated" instance. How can we do? Thanks. ...
sql 2005 server 64 bit performance
beachboy -
16 Aug 2006 8:19 AM - 3 messages
hello, any white paper from microsoft or 3rd party that show the performance differnet between 2005 sql 32 bit and 64bit edition?? Thanks in advanced. ...
Visual Fox and SQL
Simon -
16 Aug 2006 7:42 AM - 2 messages
We have a supplier that has an application written in Visual Foxpro 8 connecting to a SQL server database. Does this cause any known problems as upon testing we are finding massive problems with connection speeds and page/database locking. ...
Need to create text/xml/csv file from stored procedure
Sundar -
16 Aug 2006 7:01 AM - 3 messages
Hi I need to create multiple type of file from the stored procedure based on the input. If the user passes the parameter as txt, I have to create Text file, if XML I have to create XML file. and csv type etc . How to do this. ...
Cannot backup on c:\
ad -
16 Aug 2006 6:51 AM - 3 messages
I use SqlServerExprerss 2005 Manager to backup a DataBase to c:\aa.bak, but it fail with message "Can't open c:\aa.bak" But if the file is in the directory of C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup ...
Trace utility for SQL 2005 Express?
pedestrian via SQLMonster.com -
16 Aug 2006 6:23 AM - 5 messages
I'm using SQL Server 2005 Express. Before this, I use SQL Server 2000 there's a SQL Trace utility, is there an equivalent for SQLExpress? ...
verticall summing of columns in dbgrid
uday -
16 Aug 2006 4:48 AM - 5 messages
Hello please help me, Here inm having a dout wether can we sum the data in the column in the dbGrid. Say if we are having a column name sal can we total all the sal and ...
SQL Server 2000 CAL
AG -
16 Aug 2006 2:37 AM - 4 messages
Hi all, What does SQL Server 2000 Standard do if the number of CALs is exceeded? E.G. does it refuse the login an indicate that no more logins are allowed, or what? A client's system occassionally bogs down. It is most likely due to a poorly ...
Sql2000 enterprise Upgrade to SQL2005 Standard edition
Sankar -
16 Aug 2006 2:26 AM - 2 messages
Hi , We are using the a 4 CPU SQL Server 2000 Enterprise edition for our application , We want to migrate to SQL2005 with the compatibility level downgraded to SQL2000. If we go for the SQL2005 Standard edition is there any problem? ...
strange sql server date behavior
tascien -
16 Aug 2006 2:09 AM - 4 messages
I tried to standalize the sql server query so that I don't have problems with the date... but it is giving me error when i pass query like this: tb_Activity.DateAdded>'2006-08-15' however, it's accepting queries like these ...
Create User question
Farrukh -
16 Aug 2006 1:00 AM - 5 messages
I am a New SQL Server DBA. Today i was asked to create a user(only read-only access). So I went to Enterprise Manager than Security-->Login(Create New Login). After I created the account, I noticed the user can see and do ...
Trying to do REALLY simple procedure and loop in SQL Server
dba_222 -
16 Aug 2006 12:35 AM - 16 messages
Dear experts, Again, sorry to bother you again with such a seemingly dumb question, but I'm having some really mysterious results here. ie. Create procedure the_test As Begin Select CustomerID -----------------------------*/ Server: Msg 170, Level 15, State 1, Procedure the_test, Line 8 ...
sp4
stoney -
16 Aug 2006 12:33 AM - 2 messages
Which SQL 2000 sp4 do you install on SQL 2000 client machines? x86 32 bit servers thx ...
SP4 SQL 2000
stoney -
16 Aug 2006 12:32 AM - 2 messages
Which SP4 for SQL 2000 do you install for SQL client on x86 servers, 32 bit? thx ...
Db Maint SMTP Alerter Question
DotComDBA -
15 Aug 2006 10:24 PM - 4 messages
I'm in the process of installing and configuring alerts using the subject tool on our sql server 2000 instances but I've noticed a problem with the tool and single-quotes. It seems any alert which returns a ...
SIMPLE command to convert string to number? Not CAST or CONVERT.
dba_222 -
15 Aug 2006 10:11 PM - 6 messages
Dear Experts, Ok, I hate to ask such a seemingly dumb question, but I've already spent far too much time on this. More that I would care to admit. In Sql server, how do I simply change a character into a number?????? ...
Sql Express 1GB Memory Caching
Scott -
15 Aug 2006 8:28 PM - 2 messages
All, I have been saving large BLOBs into a Sql Express Database and notice that each time I save many records (6000) the size of "sqlservr.exe" grows each time but does not decrease in size even when I shut down the application that ...
Connection failure with VIA/GigaNet Protocol
Ron Hinds -
15 Aug 2006 7:55 PM - 2 messages
I'm trying to determine if this error ([link]) has been fixed in SQL2000 SP4 or the SP4 cumulative hotfix. I can't find it listed on MSDN, but it's ...
Query Question
WANNABE -
15 Aug 2006 6:56 PM - 5 messages
How can I get similar results from a query like this > SELECT au_lname, state FROM authors WHERE state IN ('CA', 'IN', 'MD') Except to replace ('CA', 'IN', 'MD') With a field that will have a similar format?? The Field is Misc it's contents are (100, 101, 102) and so on. I need to ...
using MSDTC for SQL linked server
csteacy -
15 Aug 2006 6:45 PM - 6 messages
Hello, I have an application that is running on W2K3 with 2005 SQL server and that has a link to another SQL server (2000). When using this application when I go to update something that would be updated on the ...
QUERY TROUBLE
Ben Watts -
15 Aug 2006 6:40 PM - 5 messages
I am using the last updated date field to give me the dates I want, but I want to narrow that search to give me only the greatest date per project id. Here is my query: SELECT POReqHdr.ProjectID, POReqHdr.User5, POReqHdr.PONbr, ...
boolean column
John -
15 Aug 2006 6:20 PM - 5 messages
How do you add a boolean column or the best alternative to a SQL Express database? ...
Query ODBC timeout
MikeChicago -
15 Aug 2006 5:27 PM - 3 messages
The query builder in enterprise Manager(Database,Tables,Table,Open Table, query) is giving me a timeout ODBC error on a long query. Is there a way to configure the query builder? I can execute the query in Query analyzer fine. ...
find who is accessing a database
Tim Kelley -
15 Aug 2006 4:53 PM - 6 messages
Is there an easy way to find out who is currently accessing a particular database? We use SQL authentication. Thanks. ...
How to find table name by Table ID
jkostic via SQLMonster.com -
15 Aug 2006 3:13 PM - 3 messages
waitresource ------------------------------ TAB: 12:600441263 [] I had blocking issue. I query sysproceses table and it shows me process are waiting for "waitresource=TAB: 12:600441263 []" TAB table 12 -- it is DB id...it is not problem to find dbname...sysdatabases ...
How to find out the Default Sort Option.
Perayu -
15 Aug 2006 3:03 PM - 4 messages
How can I find out and change the Default sort option in the Server for SQL 2K? Thanks in advance. Perayu ...
|
|||||||||||||||||||||||