|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Failed Upgrade to SQL Server 2005 SP1 - Error KB913090
mark.anderson -
16 Dec 2006 3:39 PM - 2 messages
While upgrading from SQL 2000 to 2005 last night, we experienced a failure while applying SP1 in the DATABASE SERVICES steps. We called Microsoft Software Assurance and they were able to find the problem and resolve it. The following is the problem resolution log that Microsoft ...
Linked Server Woes
news.microsoft.com -
16 Dec 2006 11:50 AM - 6 messages
Whilst experienced with SQL Server in general, I have had no exposure to linked servers. I have, therefore, been "having a play" with a view to an upcoming project. The project will involve updating a database on an external server (another ...
Calculated Fields
Liz -
16 Dec 2006 5:18 AM - 4 messages
When you use the FORMULA attribute for a column in EM does SQL Server actually store the "calculated" data or just materialize it when it's fetched ? TIA Liz ...
Default Databases and Windows Groups
Ola Hallengren -
16 Dec 2006 12:32 AM - 8 messages
Hello! I have a question about default databases and Windows groups. A Windows login is a member of two Windows groups. These two Windows groups have been granted access to a sql server. Login1 Member of Group1 and Group2 ...
'Database Mail'
Arden Smith -
15 Dec 2006 11:17 PM - 3 messages
Is 'Database Mail' supported in SQL Server express 2005 ? Thanks, Smith ...
How to use CTRL+SHIFT+INSERT to insert template in Management Stud
Kodi -
15 Dec 2006 11:17 PM - 2 messages
Hi, I am trying to create a simple template in Managament Studio editor that has "Select * from " and try to invoke it by keyboard short cut so that I don't have to type this everytime I want to type in "Select * from ". Anyone who ...
arrrgh why Java over PL/SQL
klabu -
15 Dec 2006 9:32 PM - 3 messages
arrrgh Our backend enviornment: 10gR2 <---> TIBCO <---> Java <rant> can someone please explain to me why is the damn bloody Java layer necessary ????? Am I daft to say PL/SQL can very well handle it ? ...
Linked Server Security Pass User ID
smoss -
15 Dec 2006 7:01 PM - 2 messages
We are a SQLServer 2005 shop. The intent is to be able to log onto instances on remote server with a linked server that does not include any reference to a database and no security mapping (Connection: Log on using current security ...
Loss of table permissions, DB move domain to workgroup
cynthia.l.dyer -
15 Dec 2006 6:58 PM - 4 messages
We have restored as well as tried a detach/attach of a SQL Server 2000 database from a domain environment to a workgroup environment. Doing this from server to server within the domain works great. But something happens to permissions or logins or SOMETHING when the DB is restored ...
Daylight Savings Time Change in 2007
Sally -
15 Dec 2006 6:41 PM - 2 messages
Is there a patch available for SQL Server 2000 to address the 2007 change in daylight savings time? Thank you very much in advance for your help. Thanks, Sally ...
how to shrink Trx Log
TBoon -
15 Dec 2006 5:59 PM - 3 messages
Shrink Log file does not seems to make the file size any smaller. The file size remains the even after shrinking it a few time. The GUI seems ez to use but I may be doing it wrongly. How do I shink the Log file? ...
update triggers on underlying tables of a view
nadabadan -
15 Dec 2006 5:31 PM - 7 messages
Hi, Why do all update triggers on underlying tables of a view get triggered during an update on a view while only the insert trigger of the affected table of the view gets triggered during inserts ...
Sql 2005 slow inserts/updates on large tables with indexes
Alex S -
15 Dec 2006 5:19 PM - 3 messages
Hi all. I've got a sql 2005 a/p cluster. Got 2 db's live and stage. Each db contains 3 identical tables. People - primary key clust(ID,CODE,ACCNUM), 4 separate ...
SQL Licensing in Web Environment
Sean -
15 Dec 2006 5:15 PM - 2 messages
If we have a web application that is delivering reports on data that is being pulled from a SQL Server, what exactly are my SQL Server licensing requirements? Also, if we have a web-based application that has a SQL Server backend, ...
SQL 2005 Question
shub -
15 Dec 2006 4:40 PM - 2 messages
I have a set of users who need to be able to run SQL profiler, Bulk insert and the SP_who2 command. I have been granting each users 'Adminster bulk operations',alter_trace and adding the members to the fixed server role processadmin. And in the future we will also have to ...
Anyone know how to stop a restore? "Database cannot be opened. It is in the middle of a restore.
brian.honeycutt -
15 Dec 2006 4:36 PM - 2 messages
Hi, This is my first post here. I'm running SQL Server 2000 and have a database that cannot be backed up properly because it "is in the middle of a restore." This is because of a restore that was started and then stopped. ...
Anyone know how to stop a restore? "Database cannot be opened. It is in the middle of a restore.
brian.honeycutt -
15 Dec 2006 4:24 PM - 5 messages
Hi, This is my first post here. I'm running SQL Server 2000 and have a database that cannot be backed up properly because it "is in the middle of a restore." This is because of a restore that was started and then stopped. ...
SQL Licensing in Web Environment
Sean -
15 Dec 2006 4:01 PM - 2 messages
If we have a web application that is delivering reports on data that is being pulled from a SQL Server, what exactly are my SQL Server licensing requirements? Also, if we have a web-based application that has a SQL Server backend, ...
difference between SQL_Latin1_General_CP1_CI_AS and Latin1_General
sqlextreme -
15 Dec 2006 2:24 PM - 5 messages
Hello I need to know the difference between SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS please. which is better? Thank for any help. ...
change recovery mode
Iter -
15 Dec 2006 1:52 PM - 4 messages
Hi Guys, If I change recovery mode from full to simple, do I need to reboot computer or re-start database? Thanks ...
Temp variable as AND operand
Dutt -
15 Dec 2006 12:20 PM - 4 messages
Hi Friends, I need a small help. I'm optimizing a SP.In the process, I converted a dynamic SQL query into a direct query. Excellent results rained but theres a small problem in inserting it in the SP. Let me explain it..................... ...
Deployment/copy of Db from remote server
hnteknik -
15 Dec 2006 11:22 AM - 5 messages
I need to copy both schema and data from a remote db server at my ISP. I used to use a Red Gate solution but dont have access to the proggie anymore. I then tried to use the import/export tool for the SQL 2005 server, but ...
cannot locally telnet to 1433 but Mgt Studio ok ?
Scott -
15 Dec 2006 10:52 AM - 4 messages
Hi, I have a hosted server running win2003, sql express and an app I need to connect to 1433. In a cmd prompt I enter "telnet 99.99.99.99 1433" and I cannot connect. (this works on every other server I have tested). ...
nvarchar vs varchar for .net application.
stuckish -
15 Dec 2006 9:59 AM - 2 messages
My collegue is saying that you should store text data in Sql Server i unicode fields (nvarchar) beause that .net (asp.net website) is all unicode and therefore you save some time not having to convert the data from ascii to unicode. ...
Permissions for tables and Sprocs
Nemisis -
15 Dec 2006 9:46 AM - 6 messages
Hi everyone, We are creating a new application in .net and i would like to deny access of the tables to users, but allow them to perform routines by stored procedures. I am using Sql2005, and was wondering if anyone had ...
LCS 2005
Kingjo -
15 Dec 2006 8:57 AM - 2 messages
Hi I am new to LCS 2005. We have enterprise edition installed, with sql 2000 sp3. we have users connected via the lost server pool and in the event of a failure these users would be re-routed to the alternate server farm for ...
SQL Agent job failure
Shri.DBA -
15 Dec 2006 5:15 AM - 6 messages
All, I have a job to take transaction log backup every 15 mins. Today morning the job failed while it was taking transaction log backup of the databases. When I checked for the job failure reasons I got the follwoing information ...
Backup/restore advice targeting a particular customer in database
buzlite@sympatico.ca -
15 Dec 2006 2:32 AM - 4 messages
I am considering one database instance to manage data for multiple customers. The database schema contains multiple tables with relationships to each other. I would like to know if there exists a simple method to only backup data corresponding to a particular customer. ...
EXEC stored procedure
DaveF -
15 Dec 2006 2:25 AM - 7 messages
I have a stored procedure that creates temp tables. It has two parameters, @tablename and @type. I execute it with the following command. EXEC _sp_CreateTempTable 'TableA', 'T' With these parameters, this will create a temp table named ##TMP_TableA based on the original table TableA. ...
q; Compare Two Dates
JIM.H. -
15 Dec 2006 1:50 AM - 2 messages
I need to compare tow dates DateField1 and DateField2 and find number of hours between these two dates. Then I need to deduct non-business days and hours (Business days: Monday-Friday and Business Hours: 7:00am-7:00pm) from ...
Writing update to a logging table
Jason Huang -
15 Dec 2006 1:32 AM - 2 messages
Hi, In my SQL Server 2000, I would like to write a stored procedure for a particular table TableZ which has 50 columns, and the stored procedure will check if a column in a row is changed, and write down that change to ...
8GB Ram, /PAE, /3GB, AWE etc. set Max & Min SQL memory to 6GB or 7Gb
J1C -
14 Dec 2006 11:49 PM - 4 messages
Hello all, I currently have a dedicated Win2k3 EE sever with SQL 2000 EE running with 8GB of RAM. The boot.ini is configured with /pae and /3gb - SQL Server is configured with AWE enabled and MAX Memory set to 6144MB. ...
DBCC CHECKDB
Viktor -
14 Dec 2006 10:35 PM - 3 messages
I restore backup from SQL 2000, with no esues when i run DBCC CHECKDB getting error Msg 8992, Level 16, State 1, Line 1 Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=302624121,referenced_minor_id=1) of row (class=0,object_id=173295727,column_id=0,referenced_major_id=302624121,referenced_minor_id=1) ...
Heeeelp !!! Can't insert any DATE anymore in table !
bthouin -
14 Dec 2006 9:22 PM - 4 messages
Hi I have a Dreamweaver app using ASP and working since a looong time on both SQL Server 8.0 and SQL Server 2005. I had to make a small additional page for handling some INSERTs in the database in a graceful ...
Check Server Disk Space Daily
Joe K. -
14 Dec 2006 8:32 PM - 3 messages
I know can execute perfmon program to determine disk space on the server. I would like a simple SQL Server job (SQL Server 2000) I can set up to run once a day. Check all drives on the server if unused disk space is less than ...
select count(*) from another select
magicsoft714 -
14 Dec 2006 8:11 PM - 2 messages
I am trying to get the total number of records returned by the following query. The query is: SELECT T.ID FROM tblTickets T, tblTicketHistory H WHERE T.Closed = 1 AND T.ID = H.TicketID GROUP BY T.ID HAVING COUNT(H.TicketID) < 2 ...
Scripting a database template
Thomas Mick -
14 Dec 2006 8:05 PM - 2 messages
The problem I am having is that I want to replace the sql script language in a script and call individual files containing that language from our source control. How can I call/run multiple .sql files against a database from a single ...
SQL Server running on the High Performance Cluster
WizyDig -
14 Dec 2006 7:59 PM - 4 messages
My question revolves around the High performance cluster. I was wonder if you could run SQL server on the High performance cluster if you run the Windows Data Center OS as an actual DB? Not as part of the scheduling ...
Daylight saving time SQL
Destin -
14 Dec 2006 7:31 PM - 4 messages
As you know the daylight saving time will change in 2007 [link] Microsoft realease patches for windows. But i cannot find any information about if Microsoft SQL 2000 & 2005 are affected by this change. ...
query a table on different server instance
bangwo -
14 Dec 2006 7:24 PM - 2 messages
I have a table TA in database A on SQL server instance IA and I have a stored procedure in database B on SQL server instance IB. in stored procedure I want to select all from table TA, could you tell me what is the correct select statement? ...
Question on sqlmaint scripts
DataPro -
14 Dec 2006 7:23 PM - 2 messages
New to SQL Server. I am looking at some legacy sqlmaint scripts. If I don't see the switches ReblIdx or UpdOptiStats Does that mean that there are no database reorgs and no update system catalog statistics being done? The rebuild index switch is SQL Server speak for a reorg correct? ...
How to uninstall SQL Server2005 ?
Stan SR -
14 Dec 2006 7:09 PM - 4 messages
Hi I try to uninstall sql server 2005 but it seems it doesn't want to leave me I doesn't appear in my add/remove application. Any help for this problem ? Stan ...
DBCC UpdateUsage
cbrichards via SQLMonster.com -
14 Dec 2006 6:34 PM - 4 messages
We received some consistency errors after running DBCC CheckDB and it recommended running DBCC UpdateUsage. BOL did not state whether or not DBCC UpdateUsage was an online operation, but it appears similar to updating statistics, so I assume it could be run safely without locking. Is that ...
who did it?
sali -
14 Dec 2006 6:27 PM - 2 messages
have [sql2000] database with lot of stored procedures fireing asynchronly [maybe not the best way, but that is how it is done] sometimes, there are updates/inserts into database i may not trace which event made it. is it posible, analysing transacrtion logs [or some other sql server's logs] ...
sql server 7.0 - "update statistics" - no indexes on table
lesperancer -
14 Dec 2006 5:08 PM - 3 messages
I'm running a Baan ERP application on sql server 7 Baan's application uses its own internal indexing, so no table indexes exist, nor can any be created (I've tried) I'm using ms-access to query the baan tables for reporting purposes, ...
how to get users out of sql server
Dan D. -
14 Dec 2006 4:55 PM - 5 messages
Using SS2000. We are in the process of making changes to our application. When we get ready to push a new version of the app out to users,what is the best way to get users off the system? I have a kill users script but I imagine using it could cause potential ...
Need to use "USE" in a stored Proc
shub -
14 Dec 2006 4:52 PM - 11 messages
I have a stored Procedure that I always use to restore databases.It accepts the backup file name,name of the database to be restored as amongst other parameters. It works pretty good and helps me speed up the process. However after the database is restored, I need to connect ...
automatic sequence number by id
Edgar -
14 Dec 2006 4:26 PM - 7 messages
Hi, Is it possible to have SQL server automatically generate a sequence number based on another column, both forming the table's primary key. So another kind of auto-increment field. What is mean is something like this: Code Seq Name ... ...
View SQLDmpr.mdmp File
Joe K. -
14 Dec 2006 4:23 PM - 2 messages
Is there a program that I can use to view the SQLDmpr.mdmp file? Thanks, ...
When should I use SQL Browser?
Simon Harvey -
14 Dec 2006 4:09 PM - 2 messages
Hi all, Can anyone tell me what SQL Browser is used for? Is it simply to let an ide such as management studio enummerate the available servers on a network or does it also have a function in production environments? ...
linked server to access
Mike Read -
14 Dec 2006 3:49 PM - 10 messages
I am trying to setup a linked server to an access database. SQL Server Version 2005 on a Windows 2003 server Access database is on the sql server machine. Linked Server settings: Providers: Microsoft Jet 4.0 OLE DB Provider ...
ObsoletedSprocException is being thrown
Tom -
14 Dec 2006 3:47 PM - 2 messages
I have run into a strange problem with SQL Server 2000 (SP4). I am calling a fairly simple stored procedure that selects a set of data from one table based on several parameters passed in (combination of varchar and int). ...
Returning the error message in a stored proc
grosdug -
14 Dec 2006 3:46 PM - 5 messages
Hi everyone! I know how to return an error id in a stored proc with the @@ERROR variable but is it possible to also return the corresponding error message? Thanks! ...
Can I turn browser service off with multiple nics / Ips?
sqlboy2000 -
14 Dec 2006 3:26 PM - 3 messages
All, We’d like to turn the unused services off on our production machine. Can we turn the sql browser service off under the following conditions: - No named instances - There are 2 nics that sql server needs to listen on (different IP ...
Calculating initial size tempdb
thejamie -
14 Dec 2006 3:22 PM - 3 messages
Although I may not be sure I know how to set the initial size of the tempdb (this is on a production server), I am aware from the reading I have done, that it may be possible to increase performance if the initial size of the ...
Mgmt Studio
GaryDean -
14 Dec 2006 3:06 PM - 4 messages
Can I manage MSDE databases in Management Studio? If not, how can I? How about SQL Express? When I try to attach an msde.mdf it just gets an "unknown error." ...
2K Tranaction Log Recovery with Corrupt Backup
C RAMSEY -
14 Dec 2006 3:00 PM - 5 messages
I am looking to clarify my understanding of how the SQL Server 2000 recovery processes works in full recovery mode. Given the following backup strategy 12/1/2006 8:00 PM FULL BACKUP 12/2/2006 12:00 AM TRANSACTION LOG BACKUP ...
Transferring data between instances
Alec MacLean -
14 Dec 2006 1:25 PM - 4 messages
Hi, I'm using: SQL 2000. I would like to copy data from our production instance over to my development instance, preferrably without having to write a custom program to achieve it - although if the consensus is that a program is the best ...
Foreign Keys
Shiry -
14 Dec 2006 1:20 PM - 2 messages
Hi, I'm a beginner and I'm a bit stuck here.. I'm creating this database for my homework, I'm using Marks & Spencer as an example. It has a table, products, for the clothes id name cat_id ....... connected to typ_cat ...
who understands SQL Server? --- agghhhhhhh......
deja -
14 Dec 2006 10:23 AM - 8 messages
I've got a table which is in 3 separate databases on the same server, each with different indexes. The rest of the database is the same (2 were restored from a backup of the first - i could have done 3 tables ...
Callind Stored Proc from Stored Proc
Billy -
14 Dec 2006 9:48 AM - 3 messages
I am trying to call a stored proc from within a stored proc as below, but it throws a syntax error. SELECT COUNT(*) FROM (EXEC spName) I have no access to "spName" to make any amends, currnetly it returns a ...
A question on when to use bulk logged recovery mode
Simon Harvey -
14 Dec 2006 9:28 AM - 3 messages
Hi all, I was hoping that someone could tell me a couple of scenarios where the bulk logged recovery mode is used and perhaps why? I'm guessing you might use it just before doing a large data import, but ...
failed to restore db from SQL 2005 to SQL 2000
xiaomei -
14 Dec 2006 9:16 AM - 7 messages
Hi, There, We download SQL 2005 Enterprise edt for 180-day evaluations, before that, the DB is running on SQL 2000 Std. When we did the migration, we just detach all DB and uninstall the software and installed with 2005 SQL, and again attached those DB previous working on ...
One table have many columns
Jason Huang -
14 Dec 2006 8:29 AM - 2 messages
Hi, In my SQL Server 2000, I would like to write a stored procedure for a particular table TableZ which has 50 columns, and the stored procedure will check if a column in a row is changed. Now comes the problem, since TableZ has so many columns, and I don't want ...
Log shipping trn file retention
PhilN -
14 Dec 2006 7:04 AM - 2 messages
What's the logshipping trn file retention most DBA usually set, 1,2 or 3 days? I am curious. In our production database, we set our LS file retention for 3 days and I am just wonder if it 's too long or too short. Is there a ...
copy from sql to access
hmgeri -
14 Dec 2006 6:12 AM - 2 messages
I'm attempting to do a clean up on someone else's database (whoopee!), and I think the back end is on a SQL server, front end in access. I know little about SQL and would like to get a copy into Access to work ...
urgent: SQL 2005 authentication
00MichaelJordan -
14 Dec 2006 2:16 AM - 5 messages
I tried to install SQL 2005 and I remember it asked me for the authentication and I chose mixed and input sa password. Now I uninstalled the SQL 2005 and install again. But I don't why it never asked me for the ...
Retrieve list of largest tables in a database
ozonefilter -
13 Dec 2006 10:49 PM - 7 messages
Hello, is there an easy way to retrieve a list of the largest tables in a given database? I know how to use stored procedures to retrieve the size of a single table, but I was wondering if there was a query that ...
HELP - Absurd project on a deadline!
tootsuite -
13 Dec 2006 7:53 PM - 4 messages
Hi, Someone from our headquarters wants a report of how many customers per "Metropolitation Statistical Area" (MSA) we have in our database. See [link] for the complete list of MSA's. ...
to_date(null)
klabu -
13 Dec 2006 7:22 PM - 3 messages
Please I need the equivalent of Oracle's to_date(null) Yes, NULL - this is for ODBC sake thanks ...
Query works in 2000 but not 2005
adauti -
13 Dec 2006 6:55 PM - 2 messages
I noticed that some queries work in 2000, but not in 2005, for example SELECT columnA, columnB, case when columnC = 'BLAH' then dbo.fn_func(columnD) ...
Date loop
BR -
13 Dec 2006 6:34 PM - 4 messages
Please Help! I am looking for a way to automatically loop thru dates starting 2006-01-01 thru 2006-12-01. The field I am trying to query is called endts. I need to know where endts between '2006-01-01 12:00:00AM' and '2006-01-01 ...
Change SQL 2000 Server 64bit collation
T Morris -
13 Dec 2006 6:34 PM - 4 messages
Please point me to the procedure for changing the collation sequence on 64bit installation of SQL Server 2000 (SP4). I can't find anything in KB or BOL. Thanks, Tom ...
MS SQL 2000 Server counters problem
Madroy -
13 Dec 2006 6:14 PM - 5 messages
There is a problem with using MS SQL 2000 Server performance counters. Performance counters for MS SQL aren't visible in perfmon. I've checke that there is a entry in registry (according to [link]) and ...
HyperTreading and SQL 2000 licenses.
Thinkpad21 -
13 Dec 2006 6:06 PM - 3 messages
Hi, Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how many licenses need to be configured in SQL interface. I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's ...
Server Mgmt Studio question
user -
13 Dec 2006 5:35 PM - 6 messages
Trying to get functionality of mysql query browser to work in similar manner with mssql Server mgmt studio. Using mysql query browser I can enter many statements and as long as they are terminated with a semicolon they can all exist in the query ...
VB .net in SSIS.
ChrisR -
13 Dec 2006 5:21 PM - 3 messages
Howdy all. I'm am not at all a .net guy, and don't know that I'm looking to become one. I was on a mission to accomplish something similar to what is described here: [link],1 (actually, I wanted ...
machine slow performance
bass_ua -
13 Dec 2006 5:05 PM - 6 messages
I have discovered recently that the sql server 2000 sp4 has spawned a lot of cmd.exe processes. Event viewer is full of events like: 8128 : Using 'xplog70.dll' version '2000.80.760' to execute extended stored procedure 'xp_cmdshell'. the parameter cmd,exe was called: ...
fatal exception c0000005
etm1109 -
13 Dec 2006 4:34 PM - 2 messages
My database mysteriously took a nosedive yesterday. When I attempt to debug any stored procedure inside any database, I have the following happend: Debug Window footer message indicates Waiting for Input. The system stalls for 3-5 seconds and returns this message: ...
Appending from one column to another for every row in a table
Simon Harvey -
13 Dec 2006 4:20 PM - 4 messages
Hi there, I need to carry out a database cleaning/maintenance operation whereby I take the text in one column called ShortDescription and add it to the text in a column called AdditionalDetails. I know how to copy from one to the other but that would have the effect ...
SQLserver2005 and SQLserver2000 on the same computer: cannot access SQLserver2000
acadam -
13 Dec 2006 3:48 PM - 8 messages
I've installed SQLserver2005 and SQLserver2000 on the same machine. SQLserver2005 has an instance named MyMachine and SQLserver2000 MyMachine\My2000. SQLserver2005 is accessible from any other pc on my LAN but SQL2000 is only visible on my pc; the other pc on the LAN ...
Alternatives when trying to keep two databases in sync...
jmaurer@harleysvillegroup.com -
13 Dec 2006 3:31 PM - 3 messages
I have two production SQL Server 2005 databases that I want to keep in sync ever few hours. One database is an OLTP database with high INSERT activity, the other is strictly for reporting. The OTLP database will contain data for 24 months of data. The reporting ...
SQL server 2000 (32 bit) and Windows OS (64 bit)
Praveen -
13 Dec 2006 3:30 PM - 2 messages
HI All, Can i install SQL server 2000 (32 bit) in Windows operating system (64 bit version). Thanks. ...
Users complaining of slowness
fnadal via SQLMonster.com -
13 Dec 2006 3:28 PM - 7 messages
Users are entering and saving orders through an application that writes to the database (sql server 2000 enterprise edition). Around 3:00pm users complain of slowness. It usually takes 3-4 seconds to save an order, now they are complaining that it takes over a minute. Also the spid counts go up from ...
Tedious Backup and Restore with EM
Don Miller -
13 Dec 2006 3:06 PM - 8 messages
I do a full backup on a production SQL2K database daily to one file (BAK) and hourly transaction log backups (that began after the full backup) to another file (TRN). When I transfer these two backup files to another dev ...
How do I create a script to populate a table?
groovyjman21 -
13 Dec 2006 2:21 PM - 5 messages
Using SQL Server Express 2005, SQL Server Management Studio Express: How do I create a script to populate a table? Say I have a populated table that I need to deploy with my app; isn't there a tool that can ...
Indexing of binary and varbinary
Kjell Arne Johansen -
13 Dec 2006 12:28 PM - 2 messages
Hi I’m writing an Alarms and Events database. Our A&E is identified by a byte array in the A&E object. This byte array I will store in a column of a table in addition to other columns with other relevant data. ...
TempDB Log Growth
cbrichards -
13 Dec 2006 12:16 PM - 3 messages
We are running SQL 2000, SP4, on Windows 2003. We have about 150 databases spread across about 5 servers. These databases are identical, except may differ in size, depending on the client. Yet, each server is load balanced. Recently, without any known changes on the server (let's call it Server 1), ...
MDF vs BAK file sizes
fixitchris -
13 Dec 2006 12:15 PM - 3 messages
Why are MDF and BAK file sizes a little bit different? Why are the backups of LDF files A LOT different? here is the script: use master go declare @DBname varchar(255) declare @MDFpath varchar(255) declare @LDFpath varchar(255) ...
Performance comparaison
Thinkpad21 -
13 Dec 2006 11:34 AM - 4 messages
I'm looking for a chart from Microsoft or 3rd party, showing the difference of performance of SQL 2005 compared to SQL 2000 using exactly the same hardware. Basically, we are trying to show the management that we can have performance ...
Locating recently edited tables
Ib Schrader -
13 Dec 2006 11:30 AM - 5 messages
Hi Pop quiz: Let's say a user types in "Pennsylvania Av." in his customer application. This application keeps its data in a SQL 2000 database. What would be the easiest way for me to figure out which table got updated ...
SP in a View
Dutt -
13 Dec 2006 11:14 AM - 10 messages
Hi , Is there any way to use a Sored Procedure in a View. What I mean is ' To execute the stored procedure and output some columns that could be called by the view' Thanks ...
Little SQL icon gone in SQL Server 2005??
Spin -
13 Dec 2006 11:13 AM - 4 messages
Gurus, Just installed SQL Server 2005 for the first time. Now, whenever I have installed SQL Server 2000 in the past, I am used to seeing a little gray server icon in the System tray which has either a green arrow on it if SQL ...
Does SQL Server 2005 Clean Up Unclosed Connections?
Simon Harvey -
13 Dec 2006 10:50 AM - 4 messages
Hi all, I have a quick question with regards to how SQL Server (2005) will treat conncetions that are left open (due to a programmer forgetting to close them in a .net web app). I'm basically wondering if they'll just sit their indefinately, or will ...
"pivotting" a table...
Dan Bass -
13 Dec 2006 10:40 AM - 4 messages
Greetings! I've got a simple list of id's and descriptions that I'd like to rotate so that each column is the id there exists one row which is the description for that column. Basically something like this: ...
Incorrect syntax
Daz01 -
13 Dec 2006 10:28 AM - 3 messages
Hi Im trying to build a database in Microsoft SQL Server 2005. Ive written the code, but when I execute it, I keep getting an error message (below) Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'customer'. ...
setting the number of jobs executed in parallel
Rea -
13 Dec 2006 9:57 AM - 5 messages
Hey All is there a way to set the number of jobs being executed in parallel? Is there a limit here? I am using sql server 2000 sp3 on a windows 2000 server. Thanks Rea ...
Need help with an SQL query and creating Variables for my application??
mike11d11 -
13 Dec 2006 4:51 AM - 2 messages
Right now I'm filling my dataset by adding a query to my tableadapter and filling by a specific field value in my ADO.net program. I would also like to come up with some way to replace the Specific Field "Desk" ...
Whether Service Pack Installed on SQL server 2005
sesciber -
13 Dec 2006 3:02 AM - 3 messages
I would like to find out whether service pack has been installed on SQL server 2005 or not. Any T-SQL or sp_* command can find it? ...
xp_cmdshell ACCESS IS DENIED
Joe K. -
13 Dec 2006 2:14 AM - 4 messages
I am trying to use xp_cmdshell to daily copy a SQL Server database backup file from server A to B. USE Master GO EXEC 'xp_cmdshell D:\NMEX_db_12122006.BAK \\b\K$' Output Results: Access is denied When I map a drive to Server b and drive K, I am able to copy the ...
|
|||||||||||||||||||||||