|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Exclude system IDs in 2005?
ChrisR -
29 Jul 2006 7:39 PM - 3 messages
Im trying out Profiler in 2005 for my first time, but don't see a way to exclude system IDs as was possible in 2000 on the Filters tab. Is this possible? TIA, ChrisR ...
add with null
ad -
29 Jul 2006 2:16 PM - 2 messages
I have two int fields of a table: Count1 and Count2 I select with the sql: Select Count1+Count2 as CountSum form myTable When one filed have a value and the other with null, the CountSum will be null. I wnat to treate the null value as 0 int, So I want to 2+ null=2 ...
duplicate key
mohamed abdu -
29 Jul 2006 12:41 PM - 3 messages
i am getting can not insert duplicate key row in objec how to solve with help of profiler i mean which recopred or row is the main problem who makes duplicates not allowing updates to come in db ...
SQL Enterprise Manager won't load
Doug -
29 Jul 2006 12:22 PM - 4 messages
I access my SBS2003 only by Terminal Services. The SQL Server Enterprise Manager will not load, so I am unable to access my databases/tables through the MMC. When I log on to SBS2003 Server (as administrator) I get 7 "Microsoft ...
SQL Connections vs SQL PASS
Hassan -
29 Jul 2006 8:32 AM - 2 messages
Which ones a better conference to attend ? ...
Database Engineer vs DBA
Hassan -
29 Jul 2006 7:37 AM - 5 messages
What would be the difference between these 2 job titles ? ...
URGENT: How to move SQL SERVER 2000 database
mschultz -
29 Jul 2006 7:34 AM - 3 messages
Today we were trying to backup our W2K SBS prior to migrating the applications and data to a new W2K3 SBS. Unfortunately, the W2K Server gave us the "blue screen of death" during the backup. I have archives of ...
New to Stored Procedures - Problem with simple parameter -
Ranginald -
29 Jul 2006 6:31 AM - 2 messages
When I try to save this stored procedure I get the errror: Must declare the scalar variable '@comment'. But I thought I did define it.... ====================================== CREATE PROCEDURE dbo.StoredProcedure1 ( @rating int; @comment nvarchar(1000); ...
SQL Log file "_log.ldf"
PenguinPig -
29 Jul 2006 2:56 AM - 4 messages
Dear All Someone removed some records in my table However, I haven't backup the database. Could I find out the deleted records from the _log.ldf file? Thanks ...
Request for Change form
ngan -
28 Jul 2006 11:12 PM - 2 messages
Does anyone have a sample of this form I could use? We're moving to a custom CRM package written in .NET and I'll be handing the maintanence of the CRM. I need to start developing a procedure for request ...
64bit to 32bit connectivity
dbArchitect -
28 Jul 2006 10:47 PM - 2 messages
Main Point: Views I have on my 64bit server will UNION ALL to my 32bit server to gather core data. The 32bit server view needs some staic data (CountryCode) so it INNER JOINs back to the 64bit server to get the staic ...
Table Width And Performance
Katie -
28 Jul 2006 10:40 PM - 6 messages
Hi I was wondering if you could tell me how the width of a table (number of columns) affects performance of select, update, insert and delete currently i have table with 60 columns and a million records, i was wondering how much the 60 ...
Shrink Database
Jason -
28 Jul 2006 9:36 PM - 5 messages
Hello, I am trying to shrink a database with using the following command: DBCC SHRINKDATABASE (databasename, 50, NOTRUNCATE) The process starts off fine and runs over 30 minutes and then reports back an error that transacation logs are full. How can I get around this? The database is 20gb in size with 65gb of free ...
Identify databases that have no activity
shub -
28 Jul 2006 8:57 PM - 2 messages
We have a bunch of databases in our SQL server 2000, some of them are heavily used while there are others that are not used at all or maybe used ocassionally. Is there a way to detrmine the activity of a ...
Intermitent problem : New transaction cannot enlist in the specified transaction coordinator.
Dave960 -
28 Jul 2006 8:10 PM - 8 messages
I have a Windows 2003 Application Server. When I dont use the Application for about 15 minutes, I get the error : "New transaction cannot enlist in the specified transaction coordinator" when trying to do a transaction with the Database server. ...
SQL Server 2005 chewing up processor with tempdb query
Offwhite -
28 Jul 2006 7:39 PM - 4 messages
I leave SQL Server running while not running any queries into it and it is maxing out the processor. I have been trying to stop it, but I am not making progress. I see the following query is running constantly. ...
601 - Could not continue scan with NOLOCK due to data movement.
Wonder -
28 Jul 2006 7:36 PM - 2 messages
Hi, Lately, I have been getting this problem with a client. The query returns around 6 thousand records, there is one user only and it's a select statement with a temporary table in the join. The server has a sp4 installed. It's a 2003 server. ...
truncating with foreign keys
Theresa -
28 Jul 2006 6:36 PM - 2 messages
Is there a way to truncate a table that has foreign keys without dropping them and then recreating them? Just wondering if there was an easier way around this. Thank you. ...
how to write this sql
JIM.H. -
28 Jul 2006 5:33 PM - 2 messages
I have table T1 with fields T1.ID, T1.CheckBoxCol The T2 tabel has the same ID as T2.ID and T2.CheckBox1, T2.CheckBox2, T2. CheckBox3 Now, I need to check T1 and if T1.CheckBoxCol=1 then set T2.CheckBox1=1 ...
SQLExpress size limit, is it per 4G per DB or per instance of SQLE
SheilaShovlin -
28 Jul 2006 5:06 PM - 2 messages
I just wanted to clarify whether the limit noted in your documentation for SQLExpress is 4GB per database or per instance of SQLExpress. Is there a limit per instance of SQLExpress? Cheers. - S.Shovlin ...
Troubleshoot CPU Activity - Newbie Question
Bishop -
28 Jul 2006 4:51 PM - 7 messages
Can anyone point me in the right direction? Every so often during the day our SQL 2000 server CPU will spike and sustain around 90% for quite some time. (SQL being the only process taking any sustantial CPU) We use it for ...
Query to reconcile data
Timothy.Rybak -
28 Jul 2006 4:18 PM - 6 messages
I have a table with 3 columns: Processdate ReportingPoint SerialNumber When my customer starts construction on a part, they send a broadcast to me that contains a date/time stamp, the serial number of the part, ...
Question on SQL job step invoking .cmd
Rose -
28 Jul 2006 3:23 PM - 2 messages
I have a simple SQL job that is scheduled to invoke a .cmd to perform a file copy task. How can I get SQL job to report to correct status when the copy task fails, such as due to connectivity issue, or file not found, and etc? ...
SQL Server 2000 - performance hit after restore
Dom -
28 Jul 2006 2:02 PM - 7 messages
Hi there, Just came across a weird situation. We are testing our new replacment SQL box and wanted to do some house keeping when we switch. Basically wanted to clean up file groups within database. What we have noticed that after moving some files around there was a huge performance hit ...
identify instances of server
_Stephen -
28 Jul 2006 1:56 PM - 2 messages
I have a server with both 2000 and 2005 installed. How do I define the instance name they chose when they put 2005 on it? TIA ...
In Failover Clustering password expires of windows a/c through which my SQL Services are running.
csajid -
28 Jul 2006 11:45 AM - 4 messages
Hi, I have Active / Passive cluster with following configuration. O.S. - windows 2003 Enterprise Edition SP1. H/W - 4 Processor (Xeon) + 3 GB RAM. SQL - SQL Server 2000 ED + SP3 Currently the Services of MS SQL Server are running with windows domain ...
Re: Carriage return /New line in a Text field
fmutale02 -
28 Jul 2006 10:46 AM - 3 messages
Steen Persson wrote: ...
Mainteneance plans BAK TRN
Adrian -
28 Jul 2006 9:36 AM - 9 messages
Hi All, Ive created a maintenance plan which does the following (all in one plan) * All Databases * Reorganise data, Change free space per page percentage to 10% Remove unused space from database files Shrink database when it grows beyond 50 Mb ...
CPUs and RAM limit on workgroup edition
Jackie -
28 Jul 2006 7:51 AM - 2 messages
I can find out the limit of CPUs and ram on workgroup edition are 2pc and 3GB respectively. What does this mean if I have 4 CPUs and 4GB ram in one machine? The 3GB ram limitation refers to the maximum size of memory ...
Query Optimisation
Eckhart -
28 Jul 2006 7:27 AM - 3 messages
Dear All, I am facing problem with this procedures,the multiselect queries are taking lot of time ,is there any other solution apart from indexes Regards Eckhart CREATE proc Rolexi36Sync as DECLARE @date varchar(50),@ydate varchar(50) print CONVERT(char(11),(GETDATE()-1),100) ...
SQl Server 2005 64BIT
hans-peter.zech -
28 Jul 2006 6:05 AM - 2 messages
Hello I installed all option form the CD, but I cann't found the applicationen "SQL Server Management Studio". I got in the German NG the message there isn't a version for the 64Bit, is this correct? Thank for every hint. ...
how to diagnostic performance issue?
Jeje -
28 Jul 2006 12:06 AM - 5 messages
Hi, I have a server with performance issue and I want to know why or know how to identify the cause. its for a datawarehouse SQL database. I'm using SQL 2005. during loading process or during query against the largest table (40 ...
Verify Partition Functions/ Schemes usage.
ChrisR -
27 Jul 2006 10:23 PM - 5 messages
I just create my very first Partition Function and Scheme. How do I verify that the data I insert is going into the correct Partition? Also, is it possible to do all this without multiple filegroups, or would that defeat the whole purpose? ...
Boost SQL Priority Pros and Cons
Jeff -
27 Jul 2006 10:04 PM - 5 messages
hello, I have a single, dual-processor SQL server running our companies primary application for 60 users. We are running SQL 2000 sp4 on 2000 Server, sp4. Server access via the application seems sluggish at times and I am wondering ...
Connect to a 2nd instance of SQL server while UDP 1434 is blocked
Danny Mansour -
27 Jul 2006 9:33 PM - 6 messages
I have two instances of SQL 2000 on one of our servers. I can connect to the first instance that has the machine name and port 1434 from anywhere I want. But when I try to connect to the second instance on the same machine with ...
Existing license for installed mssql server
donna.cunningham -
27 Jul 2006 8:13 PM - 2 messages
Is there a way to determine how an existing installation of MS SQL Server is licensed, both on 7.0 and 2000? Thanks for any help. Donna Cunningham ...
Data storage
Jayme -
27 Jul 2006 8:02 PM - 7 messages
Does SQL SErver comprss the data it stores? or is a varchar(50) take up that much space in the db? ...
drop and re-create table
JIM.H. -
27 Jul 2006 8:02 PM - 3 messages
What kind of problems may I see if a process drop and re-create a set of tables every night? ...
Connecting remotely without any issues.
ericzaj -
27 Jul 2006 7:34 PM - 2 messages
I already have local and remote connections enabled. What else do I have to enable? Also, I have installed all components I thought possible. How do I access or install Data Transforation Project in 2005? ...
Service startup account
coenzyme -
27 Jul 2006 7:26 PM - 3 messages
Hi everyone, I need to understand the reasons for the Service startup account settings of the General tab in the SQL Server Agent Properties. What results would transpire by changing to different local or domain account? Do you ...
Prevent user from dropping table
angani -
27 Jul 2006 6:51 PM - 4 messages
Hi gurus, Is there a way I can prevent users from dropping tables. I want my users to create and alter a table, but NOT drop a table. Can that be possible? Thank you RA ...
Dynamic SQL
Sanjay -
27 Jul 2006 6:19 PM - 2 messages
We are using dynamic SQL to insert / update in some tables using stored procs Looks like we have to grant insert / update permissions on tables to login which is executing the procs as just execute permission on proc for the login ...
Unable to connect to MSX ... error
Hong Wang -
27 Jul 2006 6:05 PM - 3 messages
I have two SQL Server 2005 servers, and want to make SQLA as Master server and SQLB as a target server. I used the 'Multi Server Administration' wizard, everything look fine until the last step, the 'Enlist target server to MSX' ...
DTS package execution time
clawdaddy -
27 Jul 2006 5:37 PM - 3 messages
Hi - I currently have a DTS package that takes raw data from a SQL table and inserts records into several tables via a custom ActiveX transformation. The package uses logic to determine which table to insert into and then calls DTSlookups to perform the inserts. The # ...
Benefits of SQL authentication?
ChrisR -
27 Jul 2006 5:36 PM - 5 messages
SQL2K SP4 I can find lots of info regarding the justification to use WINNT instead of SQL authentication. Are there any good reasons to use SQL authentication instead? TIA, ChrisR ...
Reorg select tables
Fabio Rebelo -
27 Jul 2006 5:25 PM - 4 messages
Hi, I´m not a expert DBA, please need your help!!! I have to defrag my database because poor performance, but can´t. Our database have around 1TB and don´t have disk space and window time to defrag all database at one time. ...
Proxying SQL connections
gordonah -
27 Jul 2006 5:16 PM - 3 messages
Does anyone know of a solution for proxying SQL connections? We are trying to implement an application where two layers talk to each other over SQLNet. However, where we'll have to locate the boxes means that we don't really want to use SQLNet directly .Is it possible to get the boxes ...
SQL 2005 Snapshots and Statistics
aaron n -
27 Jul 2006 4:14 PM - 3 messages
regarding snapshosts.. the docs say The database pages that are about to change are copied to the snapshot. Then the pages are updated in the main database. So the snapshot now contains the "original" copy of the changed data". ...
SQL Server error 4014. A fatal error occurred while reading the input stream from the network.
yang.jim -
27 Jul 2006 3:45 PM - 2 messages
We have MSCMS server connected to a backend clustered SQL Server 2005 EE 64bit. When in the middle of importing CMS sdo files, we got a network error and in the SQL Server error log, we found this message: A fatal error occurred while reading the input stream from the network. ...
When is a database table too large?
Henry -
27 Jul 2006 3:39 PM - 3 messages
I have a general question about using large database tables. I am well aware of relational databases and their designs, but we have a table that contains millions of rows of data, granted it only has about 5 columns. I'm wondering ...
Installing SQL Server 2005 Express Edition alongside SQL Server?
Robert -
27 Jul 2006 3:37 PM - 2 messages
I want to install SQL Server 2005 Express Edition on my laptop alongside an existing version of SQL Server, to learn SS 2005. Is there anything in particular I need to watch out for, to make sure my SS 2005 installation does ...
How to upgrade a Win32 DMO application to use DMO 9?
Sarah -
27 Jul 2006 3:22 PM - 5 messages
I have a module in my Win32 app that uses SQL DMO, but that module is no longer working under SQL Server 2005, prompting me to upgrade the DMO. I have been reading that SQL Server 2005 uses SMO instead of DMO but it can still support SQL-DMO with DMO9. ...
An Urgent help required on Performance tuning
Sathian -
27 Jul 2006 3:10 PM - 6 messages
Dear All, We use SQL Server 2000. Inorder to increase the performance archived about 2.5 million records. However after the archival, the performance is found to be reduced as you can see in the below comparison details. This downsizing of almost 2.5 ...
Licensing Windows Application Server and SQL Server
Fred Hartzler -
27 Jul 2006 3:01 PM - 2 messages
What type of licensing do I need for a Windows 200 Application Server that hosts SQL Server 2000?. (Do I need a server CAL for each SQL Server CAL?) ...
SQL Server Error
Phil Sharp -
27 Jul 2006 2:49 PM - 5 messages
Hi I am getting the following error continually on a SQL Server 2005 instance. If I reboot the server it goes away and comes back a few days later. The error than happens continuously filling up the SQL log. ...
Moving SQL Reporting Services Databases to a new server
Carlos -
27 Jul 2006 2:18 PM - 2 messages
Can anyone point me to some documents details how to move the SQL Reporting Services Databases to a new machine? we are currently using SQL Server 2000 Enterprise edition SP4. Thanks, Carlos ...
Unable to shrink Temp DB due to WorkTable
Jeff Ericson -
27 Jul 2006 2:06 PM - 2 messages
I can't shrink TempDB either by file or by database. I get the following message. DBCC SHRINKDATABASE: Page 1:825888 could not be moved because it is a work table page. TempDB on two servers that are linked together has grwon by equal amounts. ...
file or filegroup not online? "sysft_ftcat_documentindex"
Matt M -
27 Jul 2006 1:31 PM - 5 messages
Just upgraded from SQL 2000 to 2005 and I created a backup maintenance plan but I am getting the following error everytime the maintenance plan runs: Error number: -1073548784 Executing the query "BACKUP DATABASE [Clarke_MSCRM] TO DISK = N'C:\\Program ...
Combining two tables to make a third
mngong -
27 Jul 2006 1:24 PM - 4 messages
Need help combining two tables into a third with corresponding fields of both tables table 1 time 12 mike work time 13 john sleep times 24 George jump table 2 23 sam run There is a table3 which has all the columns of the two tables but i ...
how to write this SQL
JIM.H. -
27 Jul 2006 1:09 PM - 3 messages
I have a table T1 ID Desc 1 aaaa 1 bbbb 1 cccc 2 aaaa 2 cccc 3 cccc Now, I need to group by ID and make Desc column as follows in a new table ID Desc 1 aaaa, bbbb, cccc ...
q; the owner of the table
JIM.H. -
27 Jul 2006 12:24 PM - 7 messages
Hello, I need to user full name for the table as seen below. SELECT @RowCount = COUNT(*) FROM T1 c INNER JOIN [MyInstance].MyDB.dbo.T2 b ON c.T1_ID=b.T2_ID T2 may be re-created by different users, how can I get this working for all ...
sql login, trusted domain, netbios
Todd -
27 Jul 2006 11:25 AM - 3 messages
Hi everyone. I have this configuration and want to use Windows only authentication, problem is when I try and add accounts/groups from the Trusted domain, I get the following error message: "sqlserver login, unable to browse the selected domain because the following error occured: Could not find domain controller ...
Tempdb Table Sizes
MrTim -
27 Jul 2006 10:32 AM - 16 messages
Is is possible to get the sizes and/or number of rows of tables in the tempdb? I can see them in sysobjects, but sp_spaceused returns error 15009 (object does not exist). I read in a Sybase article the that some of numbers on the end of the table ...
restore a mssql2005 DB to another sql2005 server authentication pr
janwillem -
27 Jul 2006 9:22 AM - 4 messages
Hi. I want to restore a db that is created on a 2005 server to another 2005 server. From my isp i got a .BAK file. I created a new DB on the new server with same login information as the old ...
Installing MS SQL Server SP4 on SQL Server Failover Cluster.
csajid -
27 Jul 2006 8:50 AM - 3 messages
Hi, I have Active / Passive cluster with following configuration. O.S. - windows 2003 Enterprise Edition SP1. H/W - 4 Processor (Xeon) + 3 GB RAM. SQL - SQL Server 2000 ED + SP3 Now i want to apply SP4 to the SQL Server, So please tell what steps ...
MCDBA ebooks - share, exchange
king19 -
27 Jul 2006 4:09 AM - 4 messages
I'm an Oracle certified DBA. I am in need of ebooks on SQL Server Administration, preferably Microsoft ebooks. I'll share/exchange tons of Oracle DBA training ebooks for these Microsoft ones. Please let me know at tasking1***@yahoo.com. ...
Witness Server with Database Mirroring
SAM -
27 Jul 2006 2:11 AM - 5 messages
Does anyone have any recommendations on specifications for Witness server? Does it has to be as powerful as the Principal and Mirror server? Or can it be any workstation? ...
SQL Server Backup Time vs. Fragmentation
Cqlboy -
27 Jul 2006 12:29 AM - 7 messages
Does anyone know if severe index fragmentation will cause longer backups, be it Full, Diff, or log? It seems that since you have to read the data ... the more scrambled the data it is (fragmented) the longer it will take to fetch ...
New to SQL Server 2005
ericzaj -
27 Jul 2006 12:03 AM - 4 messages
I have just installed SQL Server 2005 on a Windows 2003 Server. I installed the client tools on my PC. When I connect to the 2005 SQL Server I can't move databases and I don't see the green arrow next to the instance. This even ...
SQL Profiler Question: CPU time longer then Duration?
Paul Widner -
26 Jul 2006 11:28 PM - 6 messages
Ok can anyone tell me how the CPU time (in ms) can be longer then the Duration (in ms)? I'm looking at a line in my trace the has the following: TextData: exec stpCheckin '028108228', '0000 00', '0000 00', '0001 00', ...
Tunning Processor in SQL Server.
MariaGuzman -
26 Jul 2006 10:36 PM - 2 messages
Hi, I need to estimate what is the optimum or recommended processor for a server running sql server2000, and all the databases, process, etc. that it have to run. At this moment I don´t know how to caluculate that. ...
SQL 2000 SP4 Compatibilty with DB's created in SQL 6.5
EDUAdmin -
26 Jul 2006 9:51 PM - 2 messages
Our current SQL 2000 Server has SP3a intalled and we are ready to install SP4. We have a database that was originally created on SQL 6.5. The DB inquestion is critical, are there any known SP4 compatibility issues with 6.5 ...
PERFMON inadvertently change SQL settings???
geediu -
26 Jul 2006 7:54 PM - 2 messages
Hi, On my server I was playing around with performance monitor to audit and maybe tune my server so I've set up a few counters to check for CPU and memory and IO bottlenecks. I've also set up two SQL counters like ...
Maximum Transactions
John Bailo -
26 Jul 2006 7:31 PM - 4 messages
Is there a maximum number of transactions that SQL 2000 Standard can handle at any given time? Is this configurable? ...
Transaction Logs
Jason -
26 Jul 2006 7:25 PM - 16 messages
Hi there, Currently the transaction logs were set to grow to 1000mb. I increase the growth to 1500mb and the file was still growing. Now I have set the file to grow to 2500mb and it is still growing. I would like to free up the log file ...
Transaction log size limitation on SQL 2005 standard edition
jr13 -
26 Jul 2006 6:26 PM - 8 messages
Hello, Here is my question. Is there a Transaction log size limitation on SQL 2005 standard edition as it seems to be on SQL 2000? Thanks all for your feedbacks. JR ...
Update in a Stored Procedure
mallikarjuna.rao.p -
26 Jul 2006 5:57 PM - 4 messages
Hi All, Hope some one can help me with the performance problem am facing when using an UPDATE in a Stored Procedure. I have an update statement like " UPDATE TABLEA SET COLUMNA = TABLEB.COLUMNB FROM TABLEEA , TABLE B ...
SQL 2005 install IIS warning
sqlboy2000 -
26 Jul 2006 5:56 PM - 3 messages
Hi all, I'm attempting to install SQL 2005 on a server that is not running IIS and I'm getting a warning that certain features depend on it. It points me to BOL topic - Features Supported by the Editions of SQL Server 2005. However that ...
MS SQL 2005 Workgroup licensing question
ashkaan57 -
26 Jul 2006 5:03 PM - 3 messages
Hi, I am a bit confused about the licensing schemes for MS SQL. There is a "Processor" licnese (about $4000) and a "Server + User/Device CAL" for $740 (5 CALs + $150 per additional CAL). It says: Processor Licensing Model. Under this model, a license is required for ...
CPU spike with SQL Server 2005 Express Edition
support -
26 Jul 2006 4:57 PM - 7 messages
Hello, Any help is greatly appreciated. I've recently upgraded my MSDE 2000 to SQL Server 2005 Express Edition on my Windows 2003 server SP1. I've noticted that running a single one table query against the new sql engine causes the sqlservr.exe process ...
Complex Duplicate Row Issue (Need To Keep Shorter Value)
carpeaqua -
26 Jul 2006 4:47 PM - 12 messages
a client of mine caused a bit of an issue with one of our SQL Server databases. They modified the database to create duplicate SKU values. Each SKU value has a different Name column value. What I need to do is delete the shorter value. ...
# active connections in Sql 2000
John Bailo -
26 Jul 2006 4:21 PM - 5 messages
How do I monitor the number of open connections in Sql 2000? including ones opened by ADO and .NET processes? ...
Updating Statistics
cbrichards via SQLMonster.com -
26 Jul 2006 4:20 PM - 4 messages
I need some clarification on statistics. I am running SQL 2000. I have auto create statistics and auto update statistics turned on. I run DBCC IndexDefrag weekly. I run sp_updatestats daily. It seems from running profiler that I have a high number of NO STATS warnings. ...
Index Tuning Wizard not working as I expect
bulwark_jrm -
26 Jul 2006 4:02 PM - 5 messages
Index Tuning Wizard doesn't appear to be working the way I would expect. So I have been breaking my workload down to isolate either my misunderstanding of ITW or a possible ITW problem. Basically, I have broken it down to analyzing a single query. This ...
SQL Server 2005 SP1
Keith Kratochvil -
26 Jul 2006 3:56 PM - 7 messages
I have read lots of problems installing SP1. Will SP1 install on a Windows 2003 R2 server? ...
Trigger Inserting Null Data
kyle -
26 Jul 2006 3:38 PM - 4 messages
I have a trigger set up to watch our inventory table and add an entry to a history table on any update. For some reason, a small percentage of them are coming up with all null data from the inserted and deleted ...
Converting DBF to SQL Server
michaelg via SQLMonster.com -
26 Jul 2006 3:28 PM - 4 messages
Hi, I am working with a 3rd party application that uses DBF files. We are in the process of discontinuing our contract with them and we need to convert the data to SQL Server. I setup a Linked Server to access the data, but when I ...
SQL Server 2005 and WIndows Server SBS
ashkaan57 -
26 Jul 2006 3:26 PM - 4 messages
Hi, I am begining to develop some application in Visual Studio 2005 (.NET 2.0) and was wondering if the sql server that gets shipped with SBS server is good enough or if I need to purchase 2005 version and install ...
When to use AWE
Joe Spears -
26 Jul 2006 2:57 PM - 3 messages
Hi We have a server with 8Gb memory, and 4 SQL Server instaces. Should we run AWE?? Thanks ...
MSX/TSX question between SQL 2000 and 2005
Hong Wang -
26 Jul 2006 2:56 PM - 2 messages
Hi, I have a SQL Server 2005 as a master server, I want to make a SQL Server 2000 default instance a target server, but it failed and the error message is 'The master server version 9.00.2047 is not compatible with the target server ...
SQL Server 2005 remote connection performance issues
camwyn -
26 Jul 2006 12:38 PM - 3 messages
I've got a developer in my organization who's reporting serious performance issues when he tries to back up or connect to SQL Server 2005 via Remote Desktop from his own computer. Ordinarily I'd have thought that the issues were with Remote Desktop itself, but yesterday ...
big problem with sql server 2000 msde sp 4 (stops working by accident)
Sascha Bohnenkamp -
26 Jul 2006 12:21 PM - 4 messages
Hi, I get the following error-message from sqlserver 2000 (msde edition) I have no idea what is going wrong. I was only able to get back to working state by DBCC CHECKDB ALLOW-DATA-LOSS (or restoring a backup) ...
Operating system and SQL server application on same disk set?
Dennis -
26 Jul 2006 11:30 AM - 3 messages
Dear all, Can anyone please tell me what the advantages are when placing the operating system and SQL server application on different disk sets? Or are the differences minimal when doing this? Thanks in advance, ...
Installing MS SQL 6.5 on Win 2003 Server
suhas -
26 Jul 2006 11:29 AM - 2 messages
Is it possible to install MS SQL 6.5 on Windows 2003? Can you give some information if it is possible by some Patches or MDAC ? or any spesific SP? ...
SQL 2005 Express problem creating database sqlcmd
Maxgraff -
26 Jul 2006 9:41 AM - 6 messages
Dear All, I have a sql script which runs fine on MSDE 2000 and SQL Server 2000. But when run on SQL Server 2005 Express I get all sorts of errors. Here is what I am trying to do .... On command prompt - ...
MySQL to SQL Server 2005
Ruben van Engelenburg -
26 Jul 2006 9:10 AM - 6 messages
Hi all, I have to migrate a MySQL database to SQL Server 2005. What's the best way to accomplish this? I found the msdn article about migrating MySQL to SQL Server 2000, but nothing about SQL Server 2005. I installed MyODBC on the server and made a DSN. I then tried the ...
Log Shipping - How to turn primary into secondary?
NiTiN -
26 Jul 2006 7:03 AM - 4 messages
Hi! When using transaction log shipping, I took the primary server's database offline, performed a restore of the last transaction log (with recovery) on the secondary server's database and continued work with the secondary. (I hope this is the right procedure for promoting a ...
sp:recompile problem
VSS -
26 Jul 2006 5:36 AM - 2 messages
I m getting following type of recompile for a specific sp, Exevntsubclass: 3 that is Object not found at compile time, deferred check to run time. ...
Number of Connection
prakashaspnet -
26 Jul 2006 5:33 AM - 2 messages
Hi Friends, I wants to know , number of sql server connection is active and how close the connection explicitily? Please help me Thanks Prakash.r ...
SQL 2005 Restore from file error
Jason -
26 Jul 2006 3:44 AM - 17 messages
I am running through an SSIS tutorial and I have to restore a database from a backup file. In doing so I get the following error. I am logged on to my machine as the local administrator and I have SQL 2005 developers addition ...
|
|||||||||||||||||||||||