|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Performance on a laptop vs Server...
BernardiBob -
21 May 2005 11:17 PM - 9 messages
I work for a car dealership in MA and am in the process of developing a database for an eCommerce store that will sell parts for vehicles. My challenge is that I must create forty tables of ‘mask values’ that are used ...
Database options in TPC-C test
andsm -
21 May 2005 3:01 PM - 4 messages
I read full disclosure report for best TPC-C SQL Server results, and have some questions. What is trace flag 828, where to find decription of the flag? How useful it for OLTP system under heavy load? Why checkpoint were done ...
Transaction Log not truncating after Transaction Log Backup
David Caddick -
21 May 2005 10:43 AM - 3 messages
We have a 64Bit SQL Server installation and have set up Log Shipping from the Primary Database Server, in Chicago to the Standby Database Server in New York. For the past month Log Shipping has been working very well, with no ...
Log Error
Chris Kennedy -
21 May 2005 9:08 AM - 3 messages
Hi I am getting the follow error 'log file for database dbname is full, please backup the transaction log for the database to free up some space.' running backup log dbname with truncate_only sorts it out. All's I want from ...
Transaction log backup in suspect mode
Mangesh Deshpande -
21 May 2005 4:15 AM - 3 messages
Hi I have this scenario where by data disk (mdf) is damaged. My database is running in FULL Mode and I do have all the T log backups. When I start my sql server 2000 I see it as "suspect mode" ...
Maximum databases on SQL Server 2000
Dave -
21 May 2005 4:00 AM - 2 messages
We have a Dell 2650 server with 3 GB of ram ( SQL Staandard edition ) This server is being used for heavy analysis by 10 heveyduty workstations. We have more then 1000 databases on this server. Should we limit the databases on this server ? we are having issues with ...
How to mark a system table as a user table so I can script it out ?
Hassan -
21 May 2005 2:17 AM - 2 messages
Is there a hack to mark a system table to a user table.. This is just for testing and is not in any of the sys databases.. ...
CASE Statement
sck10 -
21 May 2005 2:15 AM - 2 messages
Hello, I have a varchar field (ApprovalStatus) that can have 3 results (Approved, Denied or NULL). On my web page, I have a dropdown box which the user can select 3 items (Approved, Denied or Pending). When they choose "Pending", ...
reliable way to identify all dependencies?
David Cho -
21 May 2005 12:19 AM - 3 messages
I would like to phase out a table, but am afraid of dependencies. Right clicking on the table and selecting All Tasks >> Display Dependencies... does NOT show all dependent objects. Running a query against the syscomments table shows more! ...
Fiscal or Calendar Year Function error
sck10 -
21 May 2005 12:14 AM - 2 messages
Hello, I am trying to create a function that returns the first day of the fiscal or calendar year depending on the parameter supplied. However, I get the error: Error 443: Invalid use of the 'getdate' within a function. ...
Access 97 to SQL
Dianne -
20 May 2005 9:41 PM - 5 messages
I have an Access 97 program that for many years linked to tables in another database through drive letter access. Recently, because of speed, we converted the Access tables to a SQL Server 2000 database and linked the tables via an ODBC connection. ...
Query
Kalyan -
20 May 2005 9:21 PM - 2 messages
my query looks like this select a,c,d from aaa where some condtion union all select a,c,d from bbbb where some condtion ...
ntext problem
Ados -
20 May 2005 8:56 PM - 2 messages
Hi friends, Sorry for my not perfect English. I am new in sql, please help me with this problem. I have a table preview and table products. When the user clicks button "submit" all data from current posting in preview have to be moved in table customers. ...
DB Consistency Errors occurring frequently on random tables
Sameer Premji via SQLMonster.com -
20 May 2005 8:34 PM - 2 messages
Hi, I am using Maintenance Wizard to backup my db's and I utilize one of its features of checking database inconsistencies just before backing up. It scheduled as jobs and at 4:00PM the Integrity Check job fired and it ...
Query Cost
DXC -
20 May 2005 8:32 PM - 2 messages
What is "Query cost (relative to the batch): 100.00%" mean ? Thanks. ...
How to store euro currency symbol?
Tina -
20 May 2005 7:13 PM - 2 messages
I have a problem to store Euro symbol "€" in the MS SQL 2000 database: it is stored as "?". The database default collation used is 'SQL_latin1_General_CP1_CI_AS (code page 1252)". This doesn't support euro symbol. I found the only standard ...
Shrinking the Transaction Log
Jerry Spivey -
20 May 2005 7:11 PM - 9 messages
Hi, I've inherited a server and several databases that I'm trying to "clean up" a bit. I have a database that was about 80GB (20GB data and 60GB log). I've backed up the database and the t-log and shrunk the t-log file which ...
database marked as "Suspect"
John Grandy -
20 May 2005 6:56 PM - 3 messages
In SEM, if a database is marked as "Suspect" and no items may be viewed, what are the possible causes ? Could this be caused by the hard-drive running out of space (for either the ..mdf or the .ldf files) ? ...
Compare tables layout in dev and prod
Chen -
20 May 2005 6:23 PM - 3 messages
Hi, Does anyone know that without the tool, how to compare table's layout those are existing development and production servers? Regards, -Chen ...
Appropriate Index
DXC -
20 May 2005 6:18 PM - 2 messages
I have a table where data is deleted, inserted and updated. What kind of index is appropriate for the column where data is deleted ? where data is inserted ? where data is updated ? Thanks for any input. ...
altering a primary key property
Joel Lyons -
20 May 2005 4:59 PM - 3 messages
I need to change a primary key from clustered to nonclustered. Is there any way to do this without completely dropping and re-adding the primary key? There are several foreign keys throughout the database referencing this primary key and I was hoping to make this change without having to drop all ...
open ports
Raul -
20 May 2005 4:57 PM - 2 messages
what ports do I need to open in my router so that I can access my SQL server via IP addr? Thanks, Raul Rego ...
nested "starting up database" in the logs
Murtix Van Basten -
20 May 2005 4:06 PM - 4 messages
Hi, I noticed from the logs that, my sql server 2000 Standard Ed (runs on a windows 2k Advanced server) is starting up the databases over and over again every second. This goes on and on without stopping, like a nested loop. each ...
SQL Server 2000 build 8.00.0847 needed
Cranfield -
20 May 2005 3:44 PM - 2 messages
How do we get this build from MS? Do we need to speak to PSS or is it publicly avaialable? [link] SQL Server 2000 build 8.00.0847 ...
Transaction Isolation Level
Noel Kennedy -
20 May 2005 3:20 PM - 2 messages
Is there anyway of determining the isolation level of a connection if you don't have that connection open? IE can i tell if SPID 76 is serializable while 165 is repeatable read? Thanks, Noel Kennedy ...
max(field) but the field value is not always numeric
UGH -
20 May 2005 2:52 PM - 5 messages
I need to find the highest number in one column. Here is a catch, the column type is varchar and some of the rows will have non number character in it. I am trying to find the highest number ignoring any row that is not a numeric ...
Is LAST_INSERT_ID() same as @@IDENTITY
UGH -
20 May 2005 1:56 PM - 9 messages
In MySQL we would use LAST_INSERT_ID() to get the last identity value from the column that is set to auto number. This function is for per connection and record set so that means I will not get another person's id. ...
MS SQL Server 2000 on Windows 2003 SP1: SP3a or SP4?
Oskar -
20 May 2005 12:45 PM - 2 messages
Hi, I want to run MS SQL Server 2000 on Windows Server 2003 SP1. Would SP3a be just fine for SQL Server or should I apply SP4, which is not yet tested with the application, and why? Are there any differences between installing SQL Server 2000 on Windows 2000 ...
Notify users when stop SQL server
Dussan Pirc -
20 May 2005 11:03 AM - 7 messages
I was using "net send" when I shutdown SQL server to all connected users. After applying SP2 on XP the messenger service is not running any more. Is there any other way to alert/notify connected users that the SQL server ...
Tool to execute scripts (.sql)
CC&JM -
20 May 2005 9:41 AM - 5 messages
Does anybody knows any tool that i can use to execute .sql scripts? Thanks and best regards. ...
insert error
00allen_iverson -
20 May 2005 7:51 AM - 6 messages
I tried to insert a record to a table and it gives out the error message as attachment. Please help me. Thanks. [attached file: Doc1.doc] ...
dbo does not have a login name..
Jagminder Chugh -
20 May 2005 7:11 AM - 8 messages
Hi In one of the databases, dbo users under Users option does not have the login name.Is there any way to assign a login name "sa" to dbo. Thanks and Regards Jagminder ...
Unattend Installation of SQL Server 2000 Client Tools
HassanMullah -
20 May 2005 7:08 AM - 2 messages
hello ng My knowledge about SQL Server is equal zero ;-((, so i hope that anyoune can help me. We should package the SQL Server 2000 Client Tools on a Windows 2003 Terminalserver. The problem is, that if we install that silent ...
Log Shipping
Peretz Stern -
20 May 2005 5:16 AM - 4 messages
Which version of SQL 2000 can I run log shipping on? Thanks ...
drop clustered index - fails on duplicate key
J Jetson -
20 May 2005 1:42 AM - 3 messages
When I try to drop my unique clustered index with the following code: if exists (select * from dbo.sysindexes where name = N'my_Index' and id = object_id(N'[dbo].[my_Table]')) drop index [dbo].[my_Table].[my_Index] GO it fails with the error: ...
Representing currency?
Dean J Garrett -
19 May 2005 11:48 PM - 4 messages
We have a pretty large financial application using SQL Server 2000 and an Access front-end. We're having trouble with rounding of currency values. In the database, we're using a Real datatype for money amounts. The problem is ...
purchasing a SQL server 2000 system table poster
Edward Letendre -
19 May 2005 11:41 PM - 2 messages
I have seen a few sites on the web that was selling the SQL server 2000 system table poster. There are simular posters for Oracle 8i, 9i and 10G (which show the layout and columns of the system table spaces, such as ...
Usage statisitcs
Scott Elgram -
19 May 2005 11:16 PM - 2 messages
Hello, Ok, so maybe the information I want isn't here but I would think it should be. I am running two MS SQL 7.0 servers that have been running with very little maintenance for some time now. There are tons of tables and I ...
pre-1750 (#?!) dates in SQL table
Craig Hessel -
19 May 2005 11:12 PM - 4 messages
Sorry for incomplete info here. This is infrequent problem we have. We have SQL 2000 (sp3?). Our internet team inserts rows into a table. Don't know the mechanism they use (yet). We use a VB6 app to read the rows. Two rows have appeared in the table ...
truncating transaction logs
mb -
19 May 2005 11:06 PM - 4 messages
ok, im still confused. in my sql book ("SQL Server 2000 Unleashed") it states that backing up transaction logs 'also truncates, or clears our, the inactive portion of the log'. what does this mean? does this mean that, for ...
Newbie, Howto create trigger to delete an external image file
robdob2003 -
19 May 2005 10:51 PM - 2 messages
Hello, I'm using SQL2000 and I have a table which has a field within it called "ImageFileName", what I would like to do is create a trigger to automatcially delete the disk resident image file that is contained within ...
Memory settings/considerations when running multiple instances of SQL Server
Ken Patton -
19 May 2005 10:47 PM - 2 messages
I've got a server, Dual PIII 733's with 2gb of RAM that I setup with 3 named instances of SQL Server. I'm not sure what I should do with the memory settings, specifically the min and max and whether that has any bearing or ...
custom identity field
Stephen Brown -
19 May 2005 10:13 PM - 5 messages
I have what I thought would be a simple task but I keep hitting dead ends. My database has many tables, each with an identity column as the primary key. This worked fine until we had a requirement to import rows from other ...
difference between 'Backup' and DB maint. plan backup?
mb -
19 May 2005 9:54 PM - 5 messages
hi. ive not setup any backups under 'Management' -> 'Backup' on my SQL2000 box. instead ive used the 'Complete Backup' and ' Transaction Log Backup' tab under Database Maintenance Plans -> 'NonSystemDatabaseMaintenance'. is setting up a backup using a maintenance plan the same as setting up a ...
Restoring stored procedure HELP!
Mike -
19 May 2005 9:14 PM - 4 messages
Someone accidently deleted some of a stored procedure. Is it possible to restore just that one whole procedure, or do we have to restore DB and copy that one store procedure? ...
MSDE
Glen_in_Spokane -
19 May 2005 9:09 PM - 2 messages
Can some one tell me how to figure out which version MSDE I have loaded? It is part of some non-Microsoft software, and MBSA suggests installing paths, but I don't know what version of MSDE to select the patch for. Thank you for ...
Password Change Date
SOPONL -
19 May 2005 9:05 PM - 3 messages
Is there a way to retreive the date and time when a user last time changed his/her SQL password? I am using SQL 2000/SQL Server Authentication. TIA Sorin ...
fn Now()
rkasse -
19 May 2005 8:43 PM - 2 messages
SELECT {fn NOW()} SELECT GETDATE() both return the current datetime in sql 2000 but I have not be able to find any documentation on fn Now(). Anyone have any idea what Is the fn Now() ? ron ...
How to identify most executed queries?
Cmsn Brazil -
19 May 2005 8:31 PM - 2 messages
Hi All, is there a way to identify which are the most executed queries or stored procedures in a Sql Server 2000? I know that there are some commercial tools that does it but I don´t want to waste money on it. Any suggestion? ...
SP4
docsql -
19 May 2005 7:59 PM - 3 messages
How do you check if your sql Server is enabled with Address Windowing Extensions (AWE) support? ...
Duplicate values
DXC -
19 May 2005 7:49 PM - 4 messages
I have a table with 6 columns. I want to create a primary key for the first two columns but I am getting a message that I already have duplicate values in the combination of the two column. Can someone help me with SQL to find the duplicate rows on two columns of ...
Multiple Instances of SQL Server
Piku -
19 May 2005 7:22 PM - 3 messages
Can I install different editions of SQL Server 2000 on one server. Meaning like SQL Server 2000 Enterprise , Standard and Desktop Edition , can it be installed all together as different / multiple instances on a W2k Server...?? I know same types of database can be installed ( depending on the O.S. type ...
Difference about running and runnable
Vitor Mauricio de N. Silva -
19 May 2005 7:17 PM - 2 messages
Hi, Anybody know the difference about running and runnable when I execute sp_who ? Thanks in advance, Vitor ...
why arent trans logs getting truncated with maintenance plan?
mb -
19 May 2005 6:13 PM - 10 messages
hi. ive got a maintenance plan that im using to schedule integrity checks, db backup and transaction log backups. ive noticed, however, that my transaction logs are not being truncated when using this method of backup. Is this normal behavior? Thanks. ...
Transferring a sql server database to another server
Jack -
19 May 2005 5:36 PM - 4 messages
Hi, I need to transfer a sql server database from a NT based sql server to a Windows 2003 based sql server. I was just wondering, what is the best way to go about doing this. Any suggestion, articles is helpful. Thanks in advance. ...
Create objects calling other scripts.
CC&JM -
19 May 2005 5:26 PM - 2 messages
Hello, Can anybody tell me, how can i create one script that calls other scripts. For example, i need to create object1, object2, object3 but for control created releases i cant create my objects in the same script, so all that i ...
Newbie: Transfering databases from different servers
steve -
19 May 2005 5:15 PM - 4 messages
Hi, I have the following simple situtation: I created my database (just tables) in Server1, then made a copy to Server2. There, i changed all the datatypes and created relationships between the tables. Now, I want to transfer, not update, completely replace, all the previous ...
EM snap in
jonjo -
19 May 2005 4:28 PM - 3 messages
Hi I'm not sure if this is possible but does anyone know if there is a way to create a MMC snap in for EM and only have certain features of EM showing in that snap in e.g. not let the user see DTS jobs etc. ...
Are all DSN's really ODBC?
Maury Markowitz -
19 May 2005 4:23 PM - 5 messages
I'm still trying to learn the alphabet soup of MS's data access methods, but one thing I just noticed is that the Data Sources control panel is called "Data Sources (ODBC)". Is this accurate? If so, should I *not* use DSN's in ...
Trigger Question
John -
19 May 2005 3:54 PM - 2 messages
I am new to SQL Server and I would like to know how to do the following; I have two Tables: TableA and TableB If I do anything to TableA I would like the trigger to ...
Upgrade MSDE Instance to SP4
PaulJB PHD -
19 May 2005 3:28 PM - 2 messages
We've been distributing a named (PCIWSQL) instance of MSDE (Service Pack 3 in the MSI) along with our application. The install package was built with InstallShield. Our ProductCode at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\PCIWSQL\Setup is {5A7FE5DB-D6DF-4632-8717-0FDFE63F94FD}, which does not match any of the codes ...
Sort Order Question
Nick P. -
19 May 2005 3:22 PM - 3 messages
We are in the middle of migrating some database from SQL 7.0 to 2000 and have just found that we have a mismatch in "Sort Order" settings between the two servers. The 7.0 has the Sort order of 53 and 2000 has 52. We need to match ...
Unable to schedule DTS Packages
Stu -
19 May 2005 3:21 PM - 2 messages
I created about a dozen or so DTS (Data Transformation Services) packages that I use on a regular basis to import new data into my SQL 2000 database. Some are run monthly, and others are run weekly. I have always been able to ...
Sysindex not getting updated consistently
Vikas -
19 May 2005 2:51 PM - 7 messages
Hi, I was wondering if any of you have faced such a problem. I have some big databases which have tables having more that 100,000 records per table. The procedure here is we do lot of bulk inserts via DTS packages. Once this ...
Licence Requirements
snoko -
19 May 2005 2:21 PM - 2 messages
How many and what type of SQL Server licences are required for the following situation: One Server running SQL Server 5 users (DBA's) with Enterprise Manager etc installed on their PC's 900 users accessing the data either through a Web App or via a desktop ...
SP 4a?
Michael C# -
19 May 2005 1:30 PM - 9 messages
Anyone (maybe from MS) know when the fix for the fix is scheduled for release? ...
Internationalization
lad4bear -
19 May 2005 1:20 PM - 2 messages
Hi Guys, I need to develop a database that can handle many different languages. I've inherited part of the design and many of the text fields are defined as follows: [DETAILS_Footer] [nvarchar] (2000) COLLATE Latin1_General_CI_AS NULL If a field is declared using nvarchar, do i need to use COLLATE? And is ...
How to define a description for the table in SQL like in Access
karenmiddleol -
19 May 2005 1:17 PM - 8 messages
In Access our users are able to define descriptions for the tables and views(queries). We migrated a few Access applications to SQL Server and our users are asking for the same functionality against the SQL Server tables and views they could define descriptions. I see we can define descriptions ...
SQL 2000 server migration
Stark -
19 May 2005 12:56 PM - 3 messages
I need to move my old MS SQL 2000 server onto a new machine. My plan is the following: 1. Backup all databases from old server (including master and msdb, except tempdb). 2. Install a new fresh copy of MS SQL 2000 on new hardware. ...
When was an object last accessed?
SQLCatz -
19 May 2005 12:44 PM - 3 messages
How do I find out when an index was last used? Or, a table last accessed for a write operation - Insert, Update or Delete operation? Cheers SQLCatZ ...
Why this error: Invalid column name
dbuchanan -
19 May 2005 11:47 AM - 4 messages
Here is my straight forward update procedure. Why am I getting the Invalid column name error? ============================================ CREATE PROCEDURE dbo.usp_Process_upd( @pkProcessId char(36), @fkJob char(36), @ProcessSerial varchar(8), @fkDeviceType int, ...
Error 1038: Cannot use empty object or coymn names.Use a single sp
Jagminder Chugh -
19 May 2005 11:34 AM - 5 messages
hi, in SQL server, when list down the databases, there is a database without any name. also, when i click on the properties option of any other databases, i get the following error : "Error 1038: Cannot use empty object or coymn names. ...
Linked Server problem ?
Liam Mac -
19 May 2005 10:53 AM - 4 messages
Hi All, Can anyone help me with the folllowing problem that I'm having, when I'm using my linked server connection from a PC. Here's the overview: I have setup a linked server to another sql Server successful and created a ...
TSQL with like '_'
Anton Santa -
19 May 2005 10:51 AM - 3 messages
Hi, when executing a "select * from table where field_name like 'U_%'" only the records beginning with 'U_' should be returned. Instead all records where the fields begins with 'U' are returned. Seems the _ (underscore) is ignored. Someone knows the reason? Obviously, I can change the instruction ...
Problem with SP_addlinkedserver
news.microsoft.com -
19 May 2005 10:33 AM - 4 messages
hi right now I search a way to set the link Server with a T-Sql SCRIPT. but the problem is here that I need to set the Server Options also. is the any way to do this via T-SQL? ...
Help me send BUG report to Microsoft
Roman S. Golubin -
19 May 2005 9:50 AM - 4 messages
I wery badly speak english. I want to send to microsoft sql server developers BUG report: applies to: Microsoft SQL Server 7.0 (all versions) Microsoft SQL Server 2000 (all versions) BUG repeatability: all times script for repeat the BUG ...
BUG: Internal Server Error
Roman S. Golubin -
19 May 2005 8:41 AM - 11 messages
Hi all! MSSQL 7.0 and MSSQL2000 Server. When running query: ------------------ create table t (id int primary key identity(1,1), f int, u varchar not null default USER) GO create view v as select id, f from t where u = USER ...
sql server connection
Hassan -
19 May 2005 5:30 AM - 4 messages
Where can i find info about how a client connects to SQL. I know theres the default port 1433 and theres also the UDP port 1434. I have read this info someplace but cant seem to find it nor remember what i read ...
SQL server backups
WILLIAM -
19 May 2005 2:18 AM - 11 messages
Not knowing much about SQL, I was hoping someone could help me with a backup issue. I want my database to be backed up to disk once a day, but I would also like those BAK files to remain on the disk for a defined period of time. ...
error message when using SQL Server 7 Enterprise Manager
Edward Letendre -
19 May 2005 12:33 AM - 2 messages
I have a question, that I could not find a solution for by searching the web and this news group. Hopefully someone can make sense of this error I have been receiving for the last few months. Anyways, when I startup the enteprise manager on a SQL server 7 database ...
URGENT: The LSN (157:13095:3) passed to log scan in database is invalid
Eugene Kalinin -
18 May 2005 11:30 PM - 5 messages
SQL Server 2000 SP3, a database using Full Recovery model. During a database backup to a network drive a network error appears to have occured. Examining SQL Server logs: first a couple of errors during write to backup device Then: ...
question on query
Neil Jarman -
18 May 2005 10:00 PM - 7 messages
Hi, I need a query which returns all rows from one table and rows from another table if they are present. I also need to restrict the right hand table to certain rows. When I do this on;y the matching ros from RHS show. ...
strange
David -
18 May 2005 8:47 PM - 5 messages
I am using SQL Server 2000. I am running 2 queries. They are basically the same query 1: SELECT COUNT( Table1.Code ) AS Cnt FROM Table1 INNER JOIN Table2 on Table1.aCode = Table2.aCode AND Table2.abCode = 1 ...
Distributed Query
J. Shane Kunkle -
18 May 2005 8:12 PM - 3 messages
I would like to perform Distributed Queries on Active Directory via views in SQL Server. I have created a linked server by executing: EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject', 'adsdatasource' However whenever I run even the simplest query: ...
SQL Mail
Fred -
18 May 2005 7:34 PM - 6 messages
Hello people, I have a client that uses Lotus Notes for mail messages and he needs to send mail from SQL Server 2000. I installed Outlook 2003, got the connector to Notes, tested succesfully sending/receiving through Outlook, configured the ...
Multiple authorized reboots and the effects on SQL Server service
John Dolinka -
18 May 2005 7:15 PM - 3 messages
Is their a detrimental affect on SQL Server if the server is rebooted again shortly after a previous reboot, this may occur several times in succession? Scenario: Multiple patches have to be applied. Several patches necessitate reboot of server. Administrator applies the first round of patches, reboots and as ...
AWE
jay d -
18 May 2005 6:49 PM - 8 messages
Our current production environment consists of an 2 node (active-active) SQL Server 2000 SP3a database cluster. It was recently rebuilt and we did not reenable Address Windowing Extensions (AWE). Is it recommended that I turn it on? Both servers have 8 procs running at 2.8 Ghz and 8 GB of RAM. I am ...
SP4 Embeded Install
Eric -
18 May 2005 6:34 PM - 2 messages
Are there any plans to create an install image that already has SP4 embedded into it? ...
Moving indexes from one server to another
Vinny Vinn -
18 May 2005 5:40 PM - 3 messages
I moved my Sql Server Database from one sever to another ,Is there any way to regenerate the indexes on the server we moved to without having to recreate them? TIA, Vinny ...
SQL server 7 fisical storage
MedioYMedio -
18 May 2005 5:02 PM - 4 messages
I need to bulk insert very large amount of data into several MSSQL tables. The first Data model definition used identities to mantain relationship between those tables but we found that natural keys (compound) are better for bulk insert (there is no need to obtain the identity first) ...
Syntax error or access violation
troubleD -
18 May 2005 4:52 PM - 3 messages
hello to all! I am creating a stored procedure in sql server 2000 but when i execute it , the following error shows : [Microsoft][ODBC SQL Server Driver]Syntax error or access violation thank you. ...
Audit Logins
Adam Sankey -
18 May 2005 4:40 PM - 4 messages
Is it possible to produce a report of when each login last logged in to a server? Thanks Adam ...
IA64 SP4 Install Problem
Jim -
18 May 2005 4:40 PM - 4 messages
I am having trouble installing SP4 on my IA64. Like the instructions said in section 1.1 of the help file I have changed it to allow Unsigned drivers to Silently Succeed. However I am still getting a failure. On thing to note when I run the following command I get some different ...
SQL Reporting Services
Curtis -
18 May 2005 4:27 PM - 2 messages
I have downloaded the SQL Reporting Services 120 day eval. I have current SQL licensing and software assurance. My question is this. Will the eval. convert over to a permanent install once it sees that I have valid licensing and SA? ...
tempdb optimize
Lijun Zhang -
18 May 2005 4:22 PM - 3 messages
We have a performance issue on the very busy days caused by tempdb contentions. I increased the number of tempdb data files as described on [link] I have just returned from a SQL ...
Connect By SQL
Ivan Debono -
18 May 2005 2:44 PM - 2 messages
Hi all, Does SQL Server 2000 have something similar to START WITH and CONNECT BY like Oracle? Thanks, Ivan ...
Cannot add field
David Developer -
18 May 2005 2:25 PM - 5 messages
I tried adding a single field to our SQL 2K database in the EM and the hourglass just stays on and the change never happens. I have to cancel. I have tried this on other tables and have no problems. Can anyone help? ...
Transfering data from one server to another
Jeffrey Sheldon via SQLMonster.com -
18 May 2005 1:34 PM - 2 messages
Simple question, transfer production data to our test server via overnight backup tape. After the tape is restored to test server run sp_dropserver/sp_addserver to change the server name Change the server names on User databases But for model and msdb, is there anything I need to do to change the ...
Trigger debugging
Marco Pais -
18 May 2005 1:04 PM - 2 messages
Hi there. Is there a way to debug a trigger? I use a VB6 application running over a SQL Server 2000 database, that has several tables with triggers. Any time I want to create a new trigger, I have to test it thousand times, in order to make it fail-tolerant. ...
Log Shipping and purpose of the .tuf file
David Caddick -
18 May 2005 12:28 PM - 2 messages
We have setup Log shipping on our production Database between two different Data Centres in different cities. The process works well. All I want to know, is what is the purpose of the .tuf file? ...
|
|||||||||||||||||||||||