|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Maintenance Plan Migration Woes
F_clef -
2 Sep 2006 9:50 PM - 5 messages
Setup: 2 SQL 2005 Std Boxes (SP 1) Issue: Migrate Maintenance Plans from one box to the other 1. When I run sp_help_maintenance_plan on the source box, only the defualt is displayed although mps are displayed in the folder in Mgmt Studio. ...
sql copy database and .net framework 2.0
Per W. -
2 Sep 2006 4:11 PM - 2 messages
Hi, after installing .net framework 2.0 on a Windows 2003 server with SQL 2000 the database copy wizard get the error about permissions. The copy wizard from one server to another was okey and i run it twice before i ...
Uninstall SQL Server
noelp2000 -
2 Sep 2006 7:46 AM - 5 messages
Can I uninstall SQL server on my home computer if I don't use it? Will it interfere with my Office 2003? It installed automatically during my office 2003 installation. ...
Troubleshooting Locks with Profiler
Jerad Rose -
2 Sep 2006 3:17 AM - 4 messages
I have a couple annoying recurring locks that I am trying to troubleshoot. Basically, I set up a Profiler trace to find my long-running stored procs, and I have a couple that seem to be obvious blocking victims (very low or ...
Inner Joining Tables and Views
Marvin -
1 Sep 2006 10:56 PM - 2 messages
Is there a performance hit when Join Tables and Views? ...
sql2005 : where is the DTS graphical tool ?
bajopalabra -
1 Sep 2006 9:14 PM - 3 messages
hi in sql2000 we had a graphical tool for design several procedures like data export, exec t-sql, etc where is placed that tool on sql2005 THANKS ...
Restoring from a fixed allocated database?
Steven H -
1 Sep 2006 8:52 PM - 2 messages
We have a backup of a database that is from a database with a fixed allocation size of 300GB. The actual data itself is small, is there any way to restore this database without needing 300+GB of space? ...
Auto ID column or Natural Primary Key?
Christophe Leroquais -
1 Sep 2006 5:24 PM - 9 messages
Hi, a newbie question: i am creating a table on sql server 2005 and I am wondering what the best practices are re the ID/PK column. Is that good to create an AutoID column and set it as the PK? ...
MSDE and DTS
vaughn.haybittle -
1 Sep 2006 4:59 PM - 2 messages
Hi, I have a DTS package that I would like to execute from an application that uses MSDE as it's back end. Is it possible to 'attach' a DTS package to an MSDE database and execute it from Say example VB.Net. ...
Problems with mirroring
Thanas -
1 Sep 2006 4:33 PM - 6 messages
I have the three server ready to go. The prinicpal is set, the mirror is set. I have a back up of the prinicipal restored on the mirror and then I have a third server that acts as the witness. The problem is I ...
error in Enterprise Manager while returning all or few rows.
adi -
1 Sep 2006 3:44 PM - 6 messages
Hi, Everyone I use SQL Server Enterprise Manager to access DB server. I can connect and see the tables fine. But when i tried to open table returen all rows or open design table, I got an error saying: An unexpected error happend during this operation. ...
SQL Server remote access
Greg Smith -
1 Sep 2006 3:42 PM - 3 messages
I have just installed my first SQL2005. I can access the data via VS2005 just fine locally but when I have tried to access it remotely I get a message that remote access is not enabled. I ran the server manager and ...
max size of an update query SQL statement?
Les Caudle -
1 Sep 2006 3:20 PM - 2 messages
For a query like update tVendor set exported = 1 WHERE vendorId IN (0,1,2) how large can this be? can I have 15,000 values enclosed in the IN()? Is there any limit to the size? ...
Question installing SQL 2000 on a server already running SQL2005
MACason -
1 Sep 2006 3:17 PM - 3 messages
I have a server with SQL 2005 Enterprise Edition SP1 on Windows Server 2003 Standard. Can I install SQL 2000 SP4 on the same server. I have a vendor product that will not run on 2005 and requires SQL 2000 SP4. ...
Sql Server 2000 Enterprise
Paul Rairdon -
1 Sep 2006 3:15 PM - 2 messages
Is there anything special or different you have to do in setting up an Enterprise edition vs. a standard edition? ...
problem in restoring master database to another server
danielsanberger -
1 Sep 2006 2:49 PM - 6 messages
Hi all, I read a lot of articles about this topic, but still couldn't solve the conflict. Though having detached and attached the model and msdb, also tempdb into the correct locations, I get the following error log when starting ...
Database Mail errors
Chris Wood -
1 Sep 2006 2:35 PM - 3 messages
Hi, I thought that I had configured Database Mail correctly but I am getting this message:- Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-30T11:36:43). Exception ...
General Question: Unique Index vs. Unique Constraint
Michael D'Angelo -
1 Sep 2006 2:22 PM - 3 messages
Just a question that I've been wondering. What's the difference between creating a unique index and a unique constraint? When would you pick one over the other? ...
import data from Excel failed?
bing -
1 Sep 2006 2:13 PM - 3 messages
Hi, I needed to import data from an Excel file to a table. The error I got was: Error during Transformation 'DirectCopyXform' for Row number 4. Errors encountered so far in this task: 1. TransformCopy 'DirectCopyXform' conversion error: Destination does not allow NULL on ...
SQL 2005 express - table record number limits ?
scott -
1 Sep 2006 11:12 AM - 3 messages
Hi, Any limits on the number of records per table in 2005 express ? I seem to have a problem with 6400 I know there is a 4GB db limited but im only 40mb. Thanks for any help Scott ...
buffer cache hit ratio estimation
Marek Wierzbicki -
1 Sep 2006 8:40 AM - 5 messages
Hi I have trouble with MSSQL2000 SP4 (without any hotfixes). During last two weeks it start works anormally. After last optimalization (about few months ago) it works good (fast, without blocks). Its buffer cache hit ratio was about 99.7-99.8. Last day it starts work slow, there was many blocks and ...
Web development
Waldo -
1 Sep 2006 8:04 AM - 2 messages
Hi I have SQL Server 2005 Developer Edition. Now I want to develop a web application based on a SQL Server database. When installing SQL Server 2005, Visual Studio 2005 Premier Partner Edition is installed too. But, I can't ...
sql index usage
bz -
1 Sep 2006 6:51 AM - 5 messages
Hi! there is a table with many column including an indexed binary column (sql server 2000) If I do a select SELECT * FROM table ORDER BY bincolumn then the execution plan is a tablescan followed by a sort operation but if I do ...
Detach/Attach Via Management Studio
Andrew Hayes -
1 Sep 2006 2:57 AM - 4 messages
I really can't believe how difficult this is. Open SQL Server Management Studio, browse to the databases, right-click the one to detach, select Tasks>Detach... Check the Drop Connections checkbox, click OK... Bang! Failed. "The Database is not accessable..." pops up during the process. Click on the ...
Distributing ntwdblib.dll
Wagner Landgraf -
31 Aug 2006 11:07 PM - 4 messages
Given these facts: - There are some legacy applications that use DB-Library (ntwdblib.dll) to connect to SQL Server - There are now free SQL Server editions like MSDE and SQL Server Express, and both are supposed to work with the DB-Library ...
Windows authentication connection error to sql server 2005
Chuck Lathrope -
31 Aug 2006 10:45 PM - 4 messages
Login failed for user ''. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) SQL authentication works fine. 4 of 50 people have this issue connecting to any sql server in another domain (I would guess a one way trust as it is a ...
A few questions: Clustering & Replication
Rob -
31 Aug 2006 9:07 PM - 5 messages
Hi, In SQL 2005, with SQL Clustering: 1. Can a THREE-node active/active/active cluster be setup? If yes, is setting up a three-node a/a/a cluster recommended? Any pitfalls or gotchas that one needs to be aware of? ...
Using EXCEL to look at a VIEW - can it be edited??
Steve Z -
31 Aug 2006 9:00 PM - 5 messages
Our users all have access to our DB through a ROLE we created - this role has EXEC rights to all our stored procedures. We have never yet given a user SELECT rights to any tables... So now we are thinking that we can create a VIEW - give a user access to ...
Performance Monitor Counter Logs
iamset via SQLMonster.com -
31 Aug 2006 8:49 PM - 7 messages
What is best practice for setting up counter logs in performance monitoring? Is there such a thing? I had three counters setup to take a reading every 15minutes and got I yelled at for straining the system and I should not be saving to the same server. ...
Update Query
Bruce Schwartz -
31 Aug 2006 8:44 PM - 2 messages
I have 1 table (named Categories) with CAT_ID and name etc., and another table (named CatHierachy) that has 2 columns, P_ID and C_ID, and that links the categories to each other, creating a tree of categories and sub-categories and sub-subcategories. ...
update
Ben Watts -
31 Aug 2006 7:48 PM - 3 messages
I have two tables. Employee and Time. These 2 tables link together by their EMP_ID field. Basically I need to update the DEPARTMENT field in the Time table to be the same as the DEPARTMENT field in the Employee table when ...
Scripting Maintenance Plan in SQL Server 2005
faraujo -
31 Aug 2006 7:15 PM - 2 messages
Hello, We have about 16 servers running with SQL Server 2005, almost all have same databases replicated for users in each location, so the problem is we want to have only one maintenance plan and been able to copy or ...
Scripting Maintenance Plan in SQL Server 2005
faraujo -
31 Aug 2006 7:12 PM - 4 messages
Hello, We have about 16 servers running with SQL Server 2005, almost all have same databases replicated for users in each location, so the problem is we want to have only one maintenance plan and been able to copy or ...
50(The request is not supported.)
IndyChris -
31 Aug 2006 6:38 PM - 2 messages
I'm attempting to create an assembly in SQL Server Management Studio express and I'm getting the following error message. Msg 6502, Level 16, State 7, Line 1 CREATE ASSEMBLY failed because it could not read from the physical file ...
q; delete files
JIM.H. -
31 Aug 2006 6:15 PM - 3 messages
I need to delete all the *.txt file in a specific folder modified date is older than 2 months,. How can I do this in a stored procedure? ...
Microsoft.VC80.CRT.mui
LehrSJ -
31 Aug 2006 5:13 PM - 4 messages
I have SQL 2005, 64bit version installed with SP1. I am seeing the following errors in the Windows event log: Source: SideBySide Event ID: 59 Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui. Reference error message: Access is denied. ...
table schema
SQLken@gmail.com -
31 Aug 2006 5:08 PM - 3 messages
I am working on the sample Adventure Database that comes with SQL server 2005. The tables are group by the schema!?? i.e. company.employee company.sale etc. company is the schema and employee and sale are tables. I found this is pretty new to me. Can someone lead me to the right ...
Truncate Log (Change Recovery Model Full to Simple)
Joe K. -
31 Aug 2006 4:53 PM - 6 messages
I have a SQL Server database that has a very large database transaction log file (bf_log.ldf) that continures to grow. I would like to change the recovery model from full to simple and truncate the database transaction log file. ...
sa privileges
Eduardo Sicouret -
31 Aug 2006 4:15 PM - 6 messages
Hello, Tricky question here. I work with sql server 2000. Berfore I got here there was no DBA. So everyone used the sa user for their applications. I need to know if it's possible to remove privileges from the sa user, so I ...
Upgrading to sql 2005
johnmanc -
31 Aug 2006 4:02 PM - 3 messages
I have been assisgned the task of upgrading to sql 2005. I was given a dell poweredge 1850 and the sql standard edition 2005 w/ 5 cal disk. I have only used sql a little to make data changes in tables. My boss ...
Upgrade to SQL 2005 from SQL 2000
johnmanc -
31 Aug 2006 3:37 PM - 2 messages
I have been assisgned the task of upgrading to sql 2005. I was told there is a server and sql standard 2005 disk in the back room. I looked and found a dell poweredge 1850 and the sql standard edition 2005 w/ 5 ...
SQL 2005 Backward Compatible
george -
31 Aug 2006 3:22 PM - 7 messages
Hi, I have SQL 2000 DB that I do not want to upgrade to 2005 however I want to install 2005 and start building new DB's. Can I remove 2000 and install 2005 and connect to the old 2000 db's using Management Studio? I do not ...
sp_dboption 'trunc. log on chkpt.'
Joe K. -
31 Aug 2006 3:11 PM - 3 messages
I have a SQL Server database that the database transaction log is growing very large. The database Recovery Model is set to full. If I change the recovery model from full to simple will the transaction log truncate when the database is ...
Connect to Remote SQL SERVER Express 2005 server
Tim Kelley -
31 Aug 2006 3:01 PM - 5 messages
I am trying to connect to a remote SQL Express server (using query analyzer) and I am not able to. If I run SQL Server Managemant Studio I can connect (using Windows Authentication). I have tried using the IP address of the ...
che differenza c'è tra "user" e "login"...
input -
31 Aug 2006 2:42 PM - 3 messages
..... in SQL 2005 ??!?!? Pensavo fossero la stessa cosa ma ora non credo più... insomma ho un po' le idee confuse a riguardo. bye Grazie. ...
search
Ben Watts -
31 Aug 2006 2:26 PM - 4 messages
Is there a way to do a search inside a specific database for a specific field. My problem is I have a db with about 200 tables and I am not sure which one holds a specific field. Is there a way to find that field without ...
Changing the identity seed & increment programatically
almurph -
31 Aug 2006 2:17 PM - 5 messages
Hi, I want to change the identity values of an identity column of a table that already has rows in it, such that, it begins at zero and goes up in even numbers - that is, like 0, 2, 4, 6, 8, etc.... instead of the ...
dbcc dumptrigger
Praveen -
31 Aug 2006 2:10 PM - 2 messages
HI All, Can any one explain me the use of the DBCC command called dbcc dumptrigger Thanks and regards Praveen ...
Blocking...
Double_B -
31 Aug 2006 1:59 PM - 3 messages
Hi just read an article on the internet that states "A quick way to resolve a blocking problem is to disconnect the connection blocking the rest of the users. All you have to do is ask your database administrator to execute the KILL statement. Obviously, ...
Error when using Update Statement on a table variable
Chris Asaipillai -
31 Aug 2006 1:57 PM - 2 messages
Hi there I have a stored procedure which uses a table variable which is declared as follows: DECLARE @VtblResults TABLE ( [ROWID] INT IDENTITY(1,1) NOT NULL PRIMARY KEY ,[ClientID] INT NOT NULL ,[ContactCardID] INT ,[Name] VARCHAR(500) ,[DateRequested] DATETIME ...
User log problem
Jason Huang -
31 Aug 2006 12:04 PM - 3 messages
Hi, In my SQL Server 2000, I have a table UserTable which has all users data in it. e.g., 0001 John 123456 0002 Mary 223456 0003 Tedy 333888 .... I also has other tables ValueTAble, PreciousTable. As the table names implys, the 2 tables are very important, ...
ANSI_NULLS OFF SQL2K5
BOBNET -
31 Aug 2006 11:26 AM - 2 messages
Hi folks, I'm using SQL Server 2005 SP1 and wants to know how to set to OFF the setting ANSI_NULLS. When I create or modify a SP, SQL Server 2005 proposes automatically the settings (global) SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON ...
Point in time recovery
Double_B -
31 Aug 2006 9:19 AM - 10 messages
Hi My Backup policy is to take transaction log backups every 30 minutes... what if my server crashes at 10 minutes before a Transaction log backup takes place... e.g. Full Backup 1:00 pm Transaction Log Backup - 1:30 pm ...
Benefits of 64 bit
raidken -
31 Aug 2006 2:13 AM - 10 messages
I understand that the 64 environment allows more addressable memory. Are there any additional performance benefits other than possibly those gained by increased memory addressability? Assuming the same database running on a 32 bit environment and a 64 bit environment and applications hitting both environments with the same ...
complete backup of database except values in a particular column of a table
Arun -
30 Aug 2006 9:41 PM - 3 messages
What if we want to take complete backup of production database except values in a particular column of a table. Suppose if we don't want to reveal social Security number of employees . Can we take a backup to send the offshore team with no data in SSN column of ...
Unknown object IDs in Profile trace
Dave -
30 Aug 2006 9:36 PM - 3 messages
I am collecting objectids in a SQL Server 2000 Profiler trace. I am capturing the events: Stpred Procedures: RPC Completed and SP Completed and TSQL: SQL StmtCompleted. When I try to identify the objects being called either with object_name(id) ...
XML Export Using BCP problem
Rob Diamant -
30 Aug 2006 9:05 PM - 7 messages
I am trying to export and XML Explicit query using bcp and occasionally an element descriptor is trunctated on larger files. Any suggestions on how to avoid this problem. Is it possible to force a linefeed after each element in ...
SQL Server 2005 64Bit Edition
Phil Dowson -
30 Aug 2006 8:20 PM - 3 messages
Hi, I have a real "noob" question, and I'd appreciate it if someone could help me out. Below is the general specs of the server I am running. Product: Microsoft SQL Server Standard Edition Operating System: Microsoft Windows NT 5.2 (3790) ...
Create index question
Tim Kelley -
30 Aug 2006 7:47 PM - 4 messages
Will creating an index while a database is in use block user access? Thanks. ...
Sizing memory of SQL Server
Jonildo Santos -
30 Aug 2006 7:43 PM - 2 messages
I am going to do a sizing of memory for a server SQL Server. I am finding the calculations of memory for each user connected to the SQL Server for carry out this sizing. I stayed grateful by any help. ...
SQl server registration
saaya -
30 Aug 2006 7:24 PM - 2 messages
I register the server using SQL Server Enterprise Manager. Next day, all my settings are gone. So I need to register server everyday. ...
SQL 2000 EM security
cw -
30 Aug 2006 7:04 PM - 2 messages
When I look at the properties of the SQL Server and go to the Security Tab, the startup service account area is greyed out. Why can I not see if it's using a local system account or a domain account? ...
Help - user permissions question
tootsuite -
30 Aug 2006 6:44 PM - 10 messages
Hi, I have a database user with read-only permissions in the database. The user would like to be able to display a list of stored procedures in the database. I would like to grant this user the permission to do ...
Sql Query
John -
30 Aug 2006 6:34 PM - 3 messages
I need a SQL query that could give me a processor count and mhz info from query analyzer. Please help Thanks, John ...
Transfering User Logins & Password To A New Database
Vito Corleone -
30 Aug 2006 6:13 PM - 2 messages
Howdy Everyone, In SQL 2000, I used SQL Enterprise Mgr --> Task --> Transfer Logins Task --> Source Tab (select sourcce sql server name--> Destination Tab (select destinate sql server name) --> Logins (select database name). What about in SQL 2005? I am new at SQL 2005 but love to learn new tips. ...
Taking a backup of database without taking backup of few tables
Arun -
30 Aug 2006 5:22 PM - 17 messages
Hi All, I need to take a backup of a database without taking backup of few tables. So if i have a database Name production with a number of tables including salary table. All I want is to take the backup of complete ...
Convert an Oracle script to an SQL script
Ray Lewis -
30 Aug 2006 5:06 PM - 2 messages
I was recently given a db script that was generated from an Oracle db. I need to put the db in my SQL server using this script. Is there a tool that will convert the script for me, or do I have to do it all by hand? It will ...
updating tbl converting varchar to numeric
absoft -
30 Aug 2006 4:44 PM - 4 messages
I am importing a table in my db from a txt file having data fields separated by ' ; ' After the import, I want to make one of the field as numeric which is imported as varchar. The problem that I face converting is the data that I get can be ...
Release Database Transaction Log Used Space After Database Backup
Joe K. -
30 Aug 2006 4:32 PM - 2 messages
What are the SQL Server commands that will shrink or release database transaction log used disk space afer the database backup has completed? Thank You, ...
linked vs remote
Tony B. -
30 Aug 2006 3:46 PM - 2 messages
What are the differences between Remote Server and Linked Server anyone have a good reference page ? ...
Job fails in SQL Server 2005 Agent with error "Package not found"
Massimo -
30 Aug 2006 3:19 PM - 5 messages
Hello everybody, I am trying to run an SQL Server 2005 job which is made up of one SSIS package. The SSIS package run successfully when I start it manually, but as soon as I include it in an SQL Server Agent I get the error message mentioned in the ...
can this be done in SQL2000
Paul -
30 Aug 2006 3:18 PM - 12 messages
Hi I need to create a stored procedure that can do the following but now sure if it can be done with sql2000. 1. read in existing data from a table. 2. create the current Julian date. 3. make a comparison and add a sequence number onto this number if it is a ...
Installing SQL 2005
randy -
30 Aug 2006 3:13 PM - 2 messages
Hi, Can I install SQL 2005 side-by-side with SQL 2000? Any good articles on this? Thanks ...
Data export to individual files
pryan75 -
30 Aug 2006 3:02 PM - 2 messages
Hello, I am looking to T-SQL extract records from a table and have each record stored in individual .eml files. A query based DTS doesn't let me specify what extension my files will have AND I'm unsure how to have ...
About sys.fn_indexinfo in SQL2005 MOC 2733A
io.com -
30 Aug 2006 2:22 PM - 4 messages
Hi guys, i reading the MOC 2733A for SQL2005 and found the "sys.fn_indexinfo" function in a module 5 but when i run a sys.fn_indexinfo how indicated a error showed Seems that not exist ... it's possible ? It was replaced ? ...
"GUID should contain 32 digits" when saving brand new Maintenance
Catadmin -
30 Aug 2006 2:13 PM - 6 messages
Someone help me please. I'm confused. I've got a brand new Maintenance Plan which reorganizes indexes, clears out the MP history and updates DB stats. It refused to save with a schedule of once a week on Sunday at 1:00 a.m., but did save without a schedule (on ...
help with select
BJ -
30 Aug 2006 2:11 PM - 4 messages
I have 300 records in one table. I want to select that in 3 times, each time 100 rows. Anyone have some idea how to do that?? So, I would have 3 queries and each query would get 100 records. ...
mssql2005
news.microsoft.com -
30 Aug 2006 1:39 PM - 2 messages
how do I bring files from mssql2000 to mssql2005? A BAK from 2000 doesnt seem to work as it did in mssql97 & 2000 thanks, Raul Rego NJPIES ...
Linked Server Provider
David -
30 Aug 2006 1:11 PM - 2 messages
Hi All I am trying to create a linked server to MYSQL and it is not listed in the Linked Server providers in SQL Server 2005. How do I go about adding a provider that is not in the existing provider list? ...
Nested Transaction
shiju -
30 Aug 2006 1:06 PM - 2 messages
Hi, I wanted to know why the nested transaction is used. If I am not wrong, what I understand by the below SQL is that the "commit tran outer1" should be run to commit the entire transaction and to release the locks ...
Transaction Log Error
neeju -
30 Aug 2006 11:44 AM - 9 messages
Hi, I am trying to restore transaction log backup for one of my database using following statement. RESTORE LOG mydb FROM DISK = 'c:\mydb.trn' WITH RECOVERY GO but it is giving error like :- Server: Msg 4306, Level 16, State 1, Line 1 ...
How do I get SQL Server version (numbers only) programatically
ravidhari -
30 Aug 2006 11:31 AM - 4 messages
Hi I want to get SQL Server version. I know this way: Select @@version But this gives me a very long string, i.e. Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 18 2006 ...
A question on Isolation level
shiju -
30 Aug 2006 11:27 AM - 3 messages
Whenever the update statment is executed the patient table will be locked even for the querying. Is there a way where in the select locks the table so that the other transaction will not even able to select. If change the isolation level to repeatable read or higher it will not ...
SQL Update error
Jon -
30 Aug 2006 11:23 AM - 6 messages
Hello there. Is anyone aware of the following issue when updating a column in SQL Server 2000? I perform an UPDATE on a new column whose value is currently null. Example: UPDATE table SET column = 0 Once this is done, the values from another column (not in the quesry) are ...
Using a subquery in a update statement
Chris Asaipillai -
30 Aug 2006 11:11 AM - 4 messages
Hi I have a table with a set of possible duplicate values. The table contains information on users with the folllowing fields: Name Telephone Number Email Address DateOfBirth Duplicate Now i want to update this table (through the Duplicate flag) to set ...
Affinity mask setting in Yukon.
SQLCatz -
30 Aug 2006 10:56 AM - 6 messages
Hello, Current setup: 3 instances of SQL server 2005 on a 2 CPU box. How do I use IO/affinity to ensure that all SQL Server related I/O goes to the first CPU? I'm aware that sp_configure is the command to be used. ...
Problem with MS SQL Server 2005 Express when moving Databasefile
bluesky -
30 Aug 2006 10:12 AM - 7 messages
Hello, I have to test a .NET 2.0 Application which runs locally on my PC. All files are e.g. in the Folder DESKTOP\APPLICATION including the file LocalDB.mdf. When I started the Application for the first time, it runs ...
SQL Server Suffers Poor Performance with AWE
Damian Stalls -
30 Aug 2006 8:12 AM - 4 messages
Everytime I enable AWE on my SQL server the SQLSERVR process loses the ability to increase in memory. I am running Windows 2003 Ent. & SQL 2000 Ent. SP4. My Server has 4 processors and 8 GB of RAM. I am trying to give 5 - 6GB of RAM to ...
Reading .trc files on SQL Server 2000/2005
adkompella -
30 Aug 2006 7:49 AM - 5 messages
Hi, We have a requirement to read the .trc files generated by SQL server in real-time or atleast near real-time. We do not want to interfere with existing SQL server setup by running functions like fn_trace_get_table. The requirement is to get the events logged in .trc ...
SQL 2005 and ASP.NET 2.0
davidn -
30 Aug 2006 4:03 AM - 2 messages
All - need some help...have the above installed which is great but now I am told that the DB I am trying to run on SQL2005 requires ASP.NET 1.1 NOT ASP.NET 2.0 as the DB in question is not compatible with 2.0. I can see that ...
SQL 2000 Will Not Use More Than 3GB
Damian Stalls -
30 Aug 2006 3:37 AM - 4 messages
I have a Windows 2003 Std. server with SQL 2000 Ent. + SP4. I have placed the /3gb & /PAE in the boot.ini and enable AWE in SQL to use 6GB of RAM however after I restart the PF goes straight to 4GB and SQL will ...
Migrating from SQLServer 7/2000 to SQLServer 2005
gopi -
30 Aug 2006 1:27 AM - 3 messages
Hello All, I worked as a DBA when SQLServer 7 was released and was instrumental in migrating our SQLServer 6.5 to SQLServer 7. At that time Microsoft had released migrate/upgrade wizard that, given the source db, would create the source db on SQLServer 7 ...
SQL Server 2005 Express web usability
Bob Milutinovic -
30 Aug 2006 1:13 AM - 3 messages
Greetings, folks. I appreciate I may be asking in entirely the wrong group (as my assumptions are that this one's for discussions on the "full" version of SQL Server), but I'm hoping there'll be at least some who've encountered this situation ...
will a dts package work for this
Paul -
29 Aug 2006 11:43 PM - 8 messages
Hi, I have 2 data tables in an SQL database that normally have a new record inserted by calling 2 stored procedures from a vs.net web application. I would like to enter 1 row of new data for each table every evening (like ...
Update Contact PF from SQL Data
RayBccul-- -
29 Aug 2006 11:41 PM - 2 messages
I'm posting this question to a couple places since it crosses disciplines. I home someone out there can help me. Here's my dilemma. We have a SQL based Association Management System with customer information and we need to periodically update a Public Folder in our Exchange ...
Diagnosing source of SQL Server activity in high-volume system
Rich -
29 Aug 2006 9:34 PM - 5 messages
Hi everyone, We are running a SQL Server 2000 instance which is getting hit with hundreds of queries a minute. The vast majority of these are very short-lived, low overhead queries. Some of them are highly resouce intensive (< 1%). My problem is that lately, our SQL Server CPU ...
Scheduled Job Error
xamfear -
29 Aug 2006 9:09 PM - 6 messages
I am having an issue with a dts package. I am able to execute the package as myself from enterprise manager but I recieve an error when running it as a scheduled job. I have read [link] and am either missing ...
.dat and .idx
Ben Watts -
29 Aug 2006 8:48 PM - 3 messages
I have .idx and .dat files. I need an ODBC driver to allow me to attach to or import these tables. Anyone have any clue how to help me? ...
SQL 2005 Full Text Default Path
Ken Beard -
29 Aug 2006 8:34 PM - 5 messages
I must be missing something but for the life of me, and outside editing the registry's FullTextDefaultPath I can not find how to set a SQL 2005 instance default Full Text Path. Isn't there a better way in 2005 to do this? I see ...
Sql server sampling queires
junkpraveen -
29 Aug 2006 8:31 PM - 5 messages
Hi, can anyone provide me with a list of sample queries situations and queries for those situations .. for database like northwind ..pubs and other default dbs that come with sql .. it will act like learning ground for me .. specailly looking for joins stuff ...
|
|||||||||||||||||||||||