|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Test DTC using DTCTESTER.exe
Mark -
3 Mar 2007 9:21 PM - 4 messages
I'm trying to test that DTC is working properly on my new BizTalk 2006 servers. Using DTCTESTER.exe, I received the following error: SQLSTATE=IM002,Native error=0,msg='[Microsoft][OODBC Driver Manager] Data source name not found and no default driver specified. ...
Access controlon line level
SalamElias -
3 Mar 2007 6:53 PM - 3 messages
Is it possible to implement control access on the line level usning standard features? I had to implement several tables User, groupe, article ...., map users to groups and articles as well as some Sps in order that users or group of users ...
WebCasts
Bil -
3 Mar 2007 6:14 PM - 2 messages
Sorry to post here but does anyone know if you can download or at least print the powerpoint presentations to be able to make notes when watching them ? ...
SQL Server Agent Jobs Says Job Failed But It Did Not
childofthe1980s -
3 Mar 2007 5:56 PM - 2 messages
Hello: I just want to cover all my bases, here. For the last few days, the client's external hard drive that holds all of the backup files produced by the database maintenance plans was offline. Therefore, the backup jobs for the database backup and the transaction log ...
Need to Shrink Transaction Log
musosdev -
3 Mar 2007 5:32 PM - 11 messages
Hi everyone, I urgently need to shrink the transaction log on our MSDE2000 database. It's coming up to 3gig (for a 25mb database) and we're running out of room on the server. I think it's using Full Recovery, but more on that in a moment. ...
combo box queue(display order)
nila_vaanan -
3 Mar 2007 10:58 AM - 2 messages
Hi Table Structure company name Phone No Products Example Company Name Phone No Products Sri balaji Enterprises 26554432 Advertising Agents KarthicK Call Taxi 43215434 Call Taxi Chitra Electricals 65437654 Electricals Udhayam Call Taxi 24358901 Call Taxi Annamalaiyar Advertising 67542317 Advertising Agents ...
change recordset position
nila_vaanan -
3 Mar 2007 10:55 AM - 2 messages
Hi Table Structure company name Phone No Products Example Company Name Phone No Products Sri balaji Enterprises 26554432 Advertising Agents KarthicK Call Taxi 43215434 Call Taxi Chitra Electricals 65437654 Electricals Udhayam Call Taxi 24358901 Call Taxi Annamalaiyar Advertising 67542317 Advertising Agents ...
Integer field question
neilsolent -
3 Mar 2007 9:26 AM - 3 messages
Hi I need to create a table with an integer column that stores 2-byte numbers in the range 0..65535, and forms part of the table's primary key. Which data type should I pick? I'm torn between: ...
Optimal disk configuration for SQL
sp -
3 Mar 2007 8:01 AM - 6 messages
Optimal disk configuration for SQL I think it is: For datafiles (RAID10) Stripe Element Size 8KB – because page has 8 KB Read Policy: No read Ahead (there is a choose beetwen read ahead i adaptive read ahead) Write Policy: Write Back (there is a choose beetwen Write Through i ...
Selection the path of new db
John -
3 Mar 2007 6:13 AM - 3 messages
Hi When creating a new db in Server Management Studio how can I choose the path of the new db to F:\MyPath instead of the default? Thanks Regards ...
64 Bit Server - installing SQL Server client tools
Mark -
3 Mar 2007 5:56 AM - 3 messages
I am installing Enterprise SQL Server 2005 client tools (only) on a 64 bit BizTalk server. Are the client tools found on the Enterprise SQL Server DVD 32 or 64 bit? I assumed 64 bit. When I downloaded and attempted to install ...
SQL 2005 sp2
TomT -
2 Mar 2007 11:34 PM - 6 messages
I've seen some threads about sp2 creating problems with existing maintenance plans. Are there any known issues? If so, any advice on resolving them? Thanks ...
SQL Server 2005 Maintenance Plan Fails Everytime.
Warren -
2 Mar 2007 11:11 PM - 3 messages
Hi, I've installed SQL Server 2005 Enterprise Edition w/ SP1. I setup a maintenance plan using the wizard to backup the databases. If I run the plan manually it runs fine. I scheduled the plan to run each night.. ...
Identity Column Null? WHAT??
Theresa -
2 Mar 2007 10:58 PM - 3 messages
Hey all Wanted to check the identity of my column so I ran this: dbcc checkident (tablename) It came back saying it was null!!! "Checking identity information: current identity value 'NULL', current column value 'NULL'." What gives? When I enter a value in the column...it starts with 0. I want it ...
Transpose to Virtual Table ?
berry.sa -
2 Mar 2007 9:45 PM - 2 messages
Hi I have a database that is recording events that are occuring on a building management system, it has a table with the following data on emergency lighting tests: TIME DATA VALUE ...
Help With Another Query
Charles A. Lackman -
2 Mar 2007 8:16 PM - 2 messages
Hello and Thank You for your previous help, I have a table simular to the following: ID = int (Key) Name= VarChar Department = nChar Example Data ID Name Department 1 Chuck A ...
Help with Query
Charles A. Lackman -
2 Mar 2007 5:57 PM - 2 messages
Hello I have a table simular to the following: ID = int (Key) Temp1 = nChar Temp2 = nChar Temp3 = nChar The goal is to return something like this: SELECT Temp1+ ' ' + Temp2+ ' ' +Temp3 AS MyValue If Temp1 = "Hello" and Temp2 = "Mr." and Temp3 = "Chuck" it would return ...
Granting Select to an NT Login Group
brymer28303 -
2 Mar 2007 5:40 PM - 3 messages
I have this procdure to grant select permission to a developers group on an SQL Databse. The query executes but never returnes and the permissions are set. Can anyone tell me why the little world keeps spinning and never ...
Maintenance Plans and cleaning up backups in subfolders...
Artunc -
2 Mar 2007 5:31 PM - 6 messages
The maintenance job I have creates sub-folders for each database when it backups. The Cleanup Job is pointing to the root of this folder but it's not deleting previous backups. It's set to delete files older than 2 days. ...
Complicated Licensing Question
licensing_confusion -
2 Mar 2007 5:21 PM - 5 messages
We are currently upgrading our 2 CPU SQL Server 2000 Enterprise box to a 4 CPU box. Along with this, we are hoping to upgrade to SQL Server 2005 within a year after the hardware upgrade. The only reason we are currently running SQL Server 2000 Enterprise is ...
Table Partitioning SQL 2005
Luca -
2 Mar 2007 5:09 PM - 4 messages
HI I have to implement a retention policy on a historical table. We are using SQL Server 2005. We are thinking about 2 possible solutions: 1. Single table with SQL job that deletes records older than a specific date; ...
Reporting Services in SQL 2005
m968vuk -
2 Mar 2007 4:47 PM - 2 messages
I'm having trouble accessing reports via the reporting services in SQL 2005. I have a role created for the test account I'm using with Browser access. The only way I can see the report is if I give the test user local admin rights ...
Use a UDF in SQL Server 2000 to Encrypt/Decrypt String
Lauren Quantrell -
2 Mar 2007 3:49 PM - 6 messages
I see a lot of questions on this topic but no solutions... Does anyone know of a UDF that will encrpt and decrypt a string, such as a password string? Any help is apprecuated. lq ...
Convert serial date to date string
Rnt6872 -
2 Mar 2007 3:12 PM - 3 messages
Hi All, I have serial dates (39111.501539) in a table and I would like to convert them to this string format : 1/22/2007 12:31:05 PM. Any suggestions would be greatly appreciated. The problem exists when I ...
Why is SQL using AWE?
Ben UK -
2 Mar 2007 12:23 PM - 10 messages
I've just set up a new box (Windows 2003 (64Bit) SP1, SQL 2005 (64Bit) SP2). During testing I've found that SQL is using AWE.. ..I installed SQL via the same unattended install/default build script as every other box I've built ...
Complex counting, joining and grouping
Patrick -
2 Mar 2007 11:34 AM - 2 messages
I have a sales stats table and I want to do some counting and grouping by source and cluster (join required). The 2 tables and sample data are as follows: CREATE TABLE dbo.stat (id_source varchar(10) not null, ...
Cannot shrink transaction log of a SQL Server 2005 db
Pasquale -
2 Mar 2007 9:50 AM - 8 messages
I have a SQL Server 2005 db for a Navision installation. I have tried to execute DBCC Shrinkfile on the related transaction log after the running of backup log. I have had this error: "Cannot shrink log file 2 (...) because all logical log files are in use". ...
Table Partitioning under SQL Server 2005.
Sezgin -
2 Mar 2007 9:17 AM - 2 messages
Hi, I am looking for online hands on tutorials/examples related to table partitioning under SQL Server 2005. Regards, ...
How to check if a value is GUID ?
Sagar -
2 Mar 2007 9:01 AM - 2 messages
I have a table T, one of the columns is tColumn varchar(8000) After the table is populated, some field values in tColumn contain GUID values SELECT * from T In my SELECT I want to filter out all the rows which have a GUID ...
Create or Alter a procedure only when necessary
PFI -
2 Mar 2007 8:56 AM - 3 messages
Hi, I'm using scripts to create stored procedures... The way I'm currently doing it is the following : ------------------------------------------------------------- USE tempdb GO IF EXISTS (SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = 'test' ) ...
Is this an SQL bug (SQL 2000)?
neilsolent -
2 Mar 2007 8:49 AM - 2 messages
Hi..... Can anyone explain the following results: CREATE TABLE A ( A varchar(256) NOT NULL ) go INSERT INTO A VALUES('test') go SELECT * FROM A WHERE A LIKE 'test' go => Returns 1 row DECLARE @mytest varchar ...
Transfer Image data through DTS
Dutt -
2 Mar 2007 6:44 AM - 2 messages
Hi Friends, Cud anbody tell me how to "Transfer Image data through DTS". Any suggestion is admired. Thanks, Dutt. ...
Erro 15138
Gunawan -
2 Mar 2007 4:29 AM - 2 messages
I have this error message while trying to remove a user. What should I do now? Msg 15138, Level 16, State 1, Line 2 The database principal owns a schema in the database, and cannot be dropped. TIA, Gun ...
Can I restore SQL Server 2005 backup to SQL Server Express 2005
dbrook -
2 Mar 2007 4:06 AM - 3 messages
I have a backup of a SQL Server 2005 DB. Can I restore this to an instance of SQL Server Express 2005? ...
SQL2k: Constant subquery executed as correlated - performance problem
mzacharzewski -
2 Mar 2007 2:34 AM - 8 messages
Hi All, I have a great problem with SQL Server 2000 (Ent. Ed., sp4, 8.00.2187) performance. I don't know exactly when discribed behaviour of SQL Svr has started (maybe after sp, fix?), but I am sure, this performed well in the ...
SQL 2k
mzacharzewski -
2 Mar 2007 2:31 AM - 6 messages
Hi All, I have a great problem with SQL Server 2000 (Ent. Ed., sp4, 8.00.2187) performance. I don't know exactly when discribed behaviour of SQL Svr has started (maybe after sp, fix?), but I am sure, this performed well in the ...
query the amount of transactions in a period of time with sql server 2000
tom booster -
2 Mar 2007 1:38 AM - 2 messages
Is there a native tool (profile,trace,performance) feature I can use to determine the amount of transactions that occur throughout the day? Or is there a system table that keeps track of this(would be preferable .. less strain on the system)? ...
SQL Server 2005
Fraz -
2 Mar 2007 12:52 AM - 3 messages
We have installed SQL Server 2005 Standard Edition 64-bit on our Windows 2003 server. Now we have the server and CAL license in hand and want to add those licenses to SQL 2005. Tried using Control Panel License but SQL 2005 is not ...
SQLServer start time
cbrichards via SQLMonster.com -
2 Mar 2007 12:32 AM - 3 messages
Is there a view, function, procedure, etc. that I could obtain the last start time of SQL Server via T-SQL? We are running SQL Server 2005, SP1. ...
Database Restore Security Issue
Ken Ostrowski -
2 Mar 2007 12:25 AM - 2 messages
We are doing a restore of a SQL database to a stand alone test server. We were able to restore the database successfully to SQL Server 2000 sp3a. We restored the data into a database that has the same name as the production ...
SQL Server Database Restore
Ken Ostrowski -
2 Mar 2007 12:24 AM - 3 messages
We are doing a restore of a SQL database to a stand alone test server. We were able to restore the database successfully to SQL Server 2000 sp3a. We restored the data into a database that has the same name as the production ...
system table for DB transaction log backup
sesciber -
1 Mar 2007 10:34 PM - 2 messages
Does any system table can find the information for DB transaction log backup? ...
Query and GROUP BY
neilsolent -
1 Mar 2007 10:22 PM - 2 messages
Hi I am stuck! I have the following table: CREATE TABLE HISTORY ( PRODUCT_CODE int NOT NULL, PRODUCT_QTY int NOT NULL, SALE_TIMESTAMP datetime NOT NULL, ...
Sp_send_mail - @file_attachment problem
Henrik Juel -
1 Mar 2007 9:43 PM - 8 messages
Sqlserver 2005 sp1 with databasemail enabled. Using sp_send_mail without @file_attachments works fine. Using sp_send_mail with @file_attachments then the mail is never sent. execute msdb.dbo.sp_send_dbmail @recipients = 'x*@xx.dk', @subject = 'test', @body = 'c:\payrollnote\Pkhi001116.pdf', @file_attachments = 'c:\payrollnote\Pkhi001116.pdf' ...
Detaching a database in SQL2005 is changing the security of the files
tharris -
1 Mar 2007 8:29 PM - 3 messages
For some reason when I detach a database from my SQL 2005 server using my client machine, the security of the database files changes so that I am the only user with security to that file. It even removes all of ...
Replication Distribution Agent cpu continues to grow
fnadal via SQLMonster.com -
1 Mar 2007 7:39 PM - 5 messages
We have transactional replication set up. The agent is running on the subscriber. However the CPU continues to grow on the subscriber. Yesterday morning the cpu was about ten thousand and this afternoon it reached over a million cpu and continued to grow until I stopped and restarted the the pull ...
SQL Cluster - Automated Failover triggered by Latency or Abnormal CPU Usage
Johnny D -
1 Mar 2007 5:54 PM - 6 messages
We have a SQL Server cluster with 2 nodes, which normally runs at <10% CPU usage at all times. Whenever we have spikes through out the day, they are usually under <20% CPU usage. This SQL Server is mostly used by a third party application which ...
Migration from 2000 ro 2005 Cluster
DaveOtt26.2 -
1 Mar 2007 5:43 PM - 4 messages
Hey All, We have SQL Server 2000 in our production environment and we have a brand spanking new cluster that has more CPU power and RAM than our current server. The issue I have is how to move the data. We have 10 ...
Changing the SQL SErver DOmain
julianohorta via SQLMonster.com -
1 Mar 2007 4:48 PM - 2 messages
Hello, Anybody knows what's the effects caused by a Server Domains Change? I'm planning to change a Domain of my SQL Server that actually has a trust with the current Domain of this server. I think that I don't need to do nothing after this change. I'm correct? ...
Simple question from a beginner... Maintenance Cleanup Task
Artunc -
1 Mar 2007 4:31 PM - 4 messages
Do we type the extension of the backup file with or without (.) period? I believe in SQL2K we type (.bak), how about in SQL2K5? Thanks in advance... ...
Creating a test copy of a database?
Maury Markowitz -
1 Mar 2007 4:05 PM - 9 messages
I was wondering if there is an easy way to "copy" an existing database, complete with data, into a new one with a different name. We have a complex SQL system that imports data from an external SQL source (PervasiveSQL). We are in the process of upgrading that software to a much ...
SSRS (SQL server Reporting Services) - can it work with sql server 2000?
sadenwala -
1 Mar 2007 4:02 PM - 7 messages
Hello everyone, We have a need to use the reporting tool from SQL server. Does it work with 2000? We will not be able to upgrade to 2005 in near future. thanks for any input. ...
Config SQL Server properties to use Fixed Memory
sid -
1 Mar 2007 3:37 PM - 16 messages
Can I use an SQL statement to configure an SQL server to use Fixed Memory size as opposed to the default Dynamic ? I don't want to use the GUI. Thanks Sid. ...
Index defragmentation
Rob -
1 Mar 2007 3:36 PM - 5 messages
Is there a way to run DBCC INDEXDEFRAG for all indexes, on all tables, in a database? ...
trace dbcc statements
Mark Broadbent -
1 Mar 2007 3:08 PM - 3 messages
...this might be a daft question. is it possible to actually trace the internal statements generated by DBCC statements (because presumably they effectively use sql to query the system tables). Profiling isn't picking up anything (apart from the DBCC statement ...
Can someone provide some insight on this?
ChrisR -
1 Mar 2007 2:39 PM - 3 messages
[link] So is this saying I can purchase one license of SQL Enterprise 2005 and run it on as many vm installs as I want? Example, I create 5 windows 2003 servers ...
2000 / 2005 instances together?
Transam388 -
1 Mar 2007 2:22 PM - 4 messages
We have a 2000 SQL running with multiple instances. Can a SQL 2005 instance be loaded and run in conjunction with these 2000 instances on the same box? Are there any possible issues to look out for? Thanks! ...
Question about updating table on one server from a job on another server
Blasting Cap -
1 Mar 2007 2:20 PM - 6 messages
I have an application that is a log for purchase orders. Users enter customer info & the purchase order info into this application & data is collected in a table, sales_order_log, on one of the two databases I use ...
Cannot create compound unique index - server reports duplicate rows but there are none
pd_oflaherty -
1 Mar 2007 2:17 PM - 5 messages
Hi I am using SQL Server 2000. I have a simple table (only 6 columns) which currently contains a few hundred rows. There are two fields: SupplierGroupID and RateAdjustmentDate, the combination of which should never be repeated. I am trying to create an index with these two fields specified and the ...
WHERE clause in publication casing Error.
iKiLL -
1 Mar 2007 2:08 PM - 3 messages
Hi all Below is the error i am getting. I am trying to Create a filter on an existing publication. the filter looks like this. SELECT <published_columns> FROM [dbo].[Users] INNER JOIN [dbo].[audits] ON [audits].[pda_Audi_UserID] = [Users].[pda_User_UserId] WHERE ...
Schema Comparison Checker
Kevin Humphreys -
1 Mar 2007 1:55 PM - 4 messages
Hi There, Does anyone know of a tool that can check the schema differences between 2 databases? Thanks, Kevin. ...
Ignore errors when copying database?
stuart -
1 Mar 2007 1:55 PM - 6 messages
Hi, I am trying to copy a database from one server to another using the Copy Database Wizard in SQL2005 -but there is a bad stored procedure that makes the process fail. Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed ...
xpweb90.exe
gurbao -
1 Mar 2007 11:24 AM - 5 messages
Hi, we have sql server 2005 EE SP1 in a cluster with 3 instances. 50% CPU and when profiling I found a couple of EXECUTE [web_20070301031622647568] -- seems to have a timestamppattern in the number using more than 4 000 000 CPU ms and more than 185 000 000 reads !! ...
SQL Server 2005 rebuild master database
norman.sayers -
1 Mar 2007 9:44 AM - 3 messages
Hi, Found an issue with SQL Server 2005 when I was trying to perform a DR restore. The overview of any SQL rebuild process is to: 1. Restore OS & System State 2. Rebuild master database 3. Restore databases SQL Server 2005 does not use the rebuildm.exe command that SQL Server ...
Cascading address returns in query
CalgaryDataGrl -
1 Mar 2007 4:22 AM - 2 messages
I have a table with users. These users are joined to an address table by an intermediary table called user_address, which maps the addressids to the userids. A user can have multiple addresses, denoted in the Address table by an int identifying the type of ...
How to delete orphaned maintenance plan jobs in SQL Server 2005
Yuhong -
1 Mar 2007 3:03 AM - 3 messages
Hi, I have deleted a Maintenance Plan in SQL 2005 without deleting its job first. Now I can not delete the job. Is there any way I can delete the job? Thanks in advance for any help! ...
SQL and vbscript
Paul Bergson [MVP-DS] -
28 Feb 2007 10:16 PM - 5 messages
Trying to read a sql server 2005 table from a vendor and I'm not having any luck I'm getting the error : Invalid Object Name '_SMDBA_._CUSTOMER_' on execution of the select statement I'm not real skilled when it comes to attaching to sql. I have the sa as ...
Copying columns in one table in a DB to another Table in another DB
bfuenz via SQLMonster.com -
28 Feb 2007 10:03 PM - 2 messages
I am trying to copy two columns (OC_ID_ & OC_NAME) in one table (ORG_CHARGE) in a SQL SRV 05 DB (VFM) into two columns (DEPT_NUM and DEPT) in another table (DEPT) in another SQL SRV 05 DB (TRACK IT). I have to accomplish the ...
Assigning Execute Permissions to All My Stored Procedures
Simon Harvey -
28 Feb 2007 8:59 PM - 6 messages
Hi All, I have a database with about 250 stored procedures. I need to give some users execute permissions on all of these procedures. Can anyone tell me if there is an easy way to select a group and grant ...
Auto Backup on SQL 2005 Express
bhay@nascospg.com -
28 Feb 2007 8:43 PM - 4 messages
Is there a way to setup an automatic function to backup the databases in SQL 2005 Express? ...
17883 error
bb -
28 Feb 2007 8:03 PM - 2 messages
I have a bit of a strange problem, I'll attempt to describe it as best I can. Any directions to other resources would be appreciated. This is on SQL server 2000, with SP4 running on windows server 2003. ...
Integer or uniqueidentifier is better
SalamElias -
28 Feb 2007 7:33 PM - 3 messages
can you please give me an idea about the advantages/disadvantages between using numeric identity versus uniquidentifier in sql 2005 and which is a better choice generally? Is there an article on MSDN in a table format that lists the differences ...
View Primary Keys Clustered?
Theresa -
28 Feb 2007 6:26 PM - 12 messages
Hello! Is there a way to view which primary keys are clustered and which ones are not for all of the tables in my database? I know there is sp_helpconstraint...but I can only use this to view one table at a time. Any ...
SQL Mobile Merge Replication Questions?
iKiLL -
28 Feb 2007 5:57 PM - 3 messages
Hi all I have managed to setup the entire environment and get some C# CF code to sync to the Database and use filters. I could not have done it with out the help of these news groups. So thanks ...
archiving data
jsw -
28 Feb 2007 4:37 PM - 4 messages
Hi all hope this is in the right forum. Ive got a SQL database which accumulates about 4 million records each year. This amount causes my PC to slow down when searching, and my hard drive is getting fuller. To overcome this problem I have to delete half the records each year (2 ...
install sql
JFB -
28 Feb 2007 4:29 PM - 3 messages
Hi Folks, I have sql express in my laptop because visual studio installed for me. Now I wan to install sql developer edition. Should I upgrade sql express? How? or should I uninstall express and install developer? I want to have only developer version on my laptop, but also I'm wondering ...
Foreign key Constraint
SalamElias -
28 Feb 2007 4:28 PM - 6 messages
Hi, I sit possible to have a FK constraint between 2 tables in 2 different databases on 2 different databases Thanks in advance ...
DBCC DBREINDEX failure
Rob -
28 Feb 2007 4:19 PM - 7 messages
When I run the following DBCC command to reindex all indexes (in most cases only one: clustered) on a table... DBCC DBREINDEX (<table_name>, '', 10) It reports the following error: Could not allocate space for object ... in database ... because the ...
Installing SQL Express from command prompt
Si -
28 Feb 2007 4:01 PM - 5 messages
I'm attempted to run an installation of SQL Express 2005 from the command prompt. I've downloaded the redistributable SQLEXPR32.EXE and now want to get my hands on setup.exe, template.ini, etc.. that I will run from the command prompt. I can see them being created in a ...
find the date a sp was installed
kieran5405 -
28 Feb 2007 3:33 PM - 7 messages
hi, i know how to check what version of service pack i have installed on sql server 2000...but does anyone know how to find out the date it was installed on. i am having probs with sql server agent and can see the date the probs ...
SQL 2000 and SQL 2005
Elbryyan -
28 Feb 2007 2:56 PM - 6 messages
Is it possible to have SQL 2000 standard and SQL 2005 enterprise running on the same machine? ...
How to return text data type from stored procedure.
Archana -
28 Feb 2007 2:13 PM - 2 messages
Hi all, I am having one stored procedure which is returing parameter having text data type. This paramter has to take value from table which have column with datatype as text. How will i set value to parameter having text datatype to value ...
Database Starting Up
Adam Sankey -
28 Feb 2007 2:11 PM - 5 messages
I have a database which constantly saying it i starting up!!!! 2007-02-28 12:32:22.96 spid63 Starting up database 'QA_Test'. 2007-02-28 12:32:22.98 spid63 Starting up database 'QA_Test'. ...
Fastest way to insert?
Joe Grizzly -
28 Feb 2007 1:51 PM - 10 messages
Hi, I'm trying to figure out if doing an INSERT INTO.. a table with indexes is faster (or slower) than doing a SELECT INTO and then creating the indexes on the table created. The table in question contains around a million records. ...
Why won't the log truncate internally? (I'm NOT trying to shrink the file itself!)
SQL_Beginner -
28 Feb 2007 1:43 PM - 7 messages
No, this is not another question about why my log file is so large. I have a client whose log file is 2.8 GB. This is not a problem. Database is in full recovery. We take transaction log backups every 20 ...
faster?
Meelis Lilbok -
28 Feb 2007 10:54 AM - 9 messages
Hi what is faster - LEFT JOIN or subselect example SELECT T.TITLE,S.ID FROM TITLES T LEFT JOIN SINDEXES S ON T.ID=S.TITLE_ID or SELECT T.TITLE,(SELECT ID FROM SINDEXES WHERE T.ID=TITLE_ID) Mex ...
About server authentication
Daatmor -
28 Feb 2007 10:45 AM - 4 messages
Hi, I've enabled the SQL Server and Windows Authentication mode, and then I restarted the SQL server. My ASP.NET program can be access the server, but I found that I cannot login the SQL server using Microsoft SQL Server ...
SQL Server 2000 "cloning"
Andrew Drake -
28 Feb 2007 10:37 AM - 3 messages
Dear all, I have to migrate an SQL Server 2000 to a new machine because the old one experiences some hardware problems. There will be no changes in the configuration during the migration - the new system should be exactly the same as the old one (including the name / IP ...
SQL Server 2005 Linked Servers
nnsoni -
28 Feb 2007 9:36 AM - 5 messages
Hi, I am using 2 servers with SQL Server 2005 installed on them. I have 1 Database (say the Corporate Database) on Server A and the other databases (say the Department Database) on Server B. All the core tables that are shared across all the departments are stored in the ...
Users & Column Access
hufaunder@yahoo.com -
28 Feb 2007 7:43 AM - 5 messages
I have a server/client application that has multiple users with different access rights to the data in a database. Access is granted on a column level. First I was planning on writing my own autorization/ authentication layer. Then I was told that the right way to do this is ...
AUTOCLOSE
AMBROSE -
28 Feb 2007 3:59 AM - 8 messages
What does autoclose do ? And why Starting up database message is repeated when autoclose is true? ...
64 bit 60 gb db with RAID 10 4 VOLUME
Jay -
28 Feb 2007 3:59 AM - 6 messages
I am working with SQL 2005 64 bit sp1 , i am facing problem continues in error log file mentioned below, can you please help me SQL Server has encountered 1 occurrence(s) of I/O requests taking longer ...
Can SQL Server 2005 Workgroup Ed be installed on a server with 4G
Harvey Hall -
28 Feb 2007 3:18 AM - 3 messages
SQL Server 2005 Workgroup Ed is limited to 3GB RAM. Does that mean it cannot use more than 3GB RAM under any circumstances, but it can be installed on a server having more than 3GB total RAM; or, does that mean that it cannot be ...
Cannot make remote connection to SQL Server Express
dan -
27 Feb 2007 11:07 PM - 2 messages
I'm having trouble making a remote connection to a SQL Server Express database. The service is started, and the connection works locally. I tested it using a .udl. In this local .udl, I use the SQL Native Client as the provider, and a Data Source entry of (local)\SQLEXPRESS, ...
Enterprise Manager blocks network on XP
steven.cardinal -
27 Feb 2007 8:28 PM - 3 messages
I'm running XP SP2 (and all the latest hotfixes) and administer a bunch of SQL2000 servers. Whenever I have enterprise manager running, I find that my network access seems to block regularly. What I mean by that is, If I open Explorer and try to access network drives, explorer ...
2005 - Need to Shrink Log File
Terry Carnes -
27 Feb 2007 8:09 PM - 4 messages
Is there a way to shrink the log file below it's Initial Size? Somehow the initial size for a log file was accidentally set to 25 Gig. This extra large log file is keeping the backups from working (no disk space). ...
3701 Errors after installing SP2
Barb -
27 Feb 2007 6:51 PM - 3 messages
Environment: SQL Server 2005 Enterprise Edition SP2 Windows 2003 R2 x64 Enterprise 80+ Databases, all upgraded to compatibility 90 Since upgrading to SP2 for SQL Server 2005, my scheduled jobs based on Maintenance Plans which include Statistics Updates, Index Rebuilding and ...
Recovery sans backup
kpg -
27 Feb 2007 6:17 PM - 3 messages
Hi all, I have (had) a development machine with sql svr 2k running, it was only used to test the software we developed. Well, the sql server machine died, it still boots and the drives are accessabe. but sql server won't start (as won't many other ...
Backup plan cannot find the path specified
childofthe1980s -
27 Feb 2007 6:03 PM - 2 messages
Hello: In continuing with a posting that I made yesterday here on the Newsgroups, I have today reviewed the SQL Error Log for a database maintenance plan that I have that backups my databases to an external hard drive. The backup to this external hard drive is failing for all of the databases! ...
User Provisioning Tool for Vista part of SP2 Upgrade
Chris Wood -
27 Feb 2007 5:34 PM - 3 messages
Hi, This option appears as part of the SP2 setup process. If you do not check the Launch button can it be run at a later time? If you are not currently running VISTA but will move to VISTA at a later date should it be run at SP2 ...
|
|||||||||||||||||||||||