|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
AWE on 2003 x64 with SP4 and 8 gigs of memory.
et -
14 Jan 2006 9:01 PM - 4 messages
I just bought a nice new server with EMT64 ( we have to buy Dell :( ). It has 8 gigs of memory. It is running Windows 2003 Std x64 edition and the OS detects all of the 8 gigs. I installed SQL 2000 SP4 Enterprise edition and applied SP4. I restored a ...
Upgrade/Downgrade from SQLEXPRESS to SQL 2000 for Windows Sharepoint Services!?
Jörg Schreiber -
14 Jan 2006 8:15 PM - 3 messages
I was told that it might be better to post here - so sorry in advance for cross posting that... Hello, due to technical probs with our VPS-System i had to try an installation of SQLEXPRESS and i finally made our Windows Sharepoint Services (on ...
SQL Server 2005 Standard "Launch Pack" on Ebay
Bababooey -
14 Jan 2006 4:30 PM - 9 messages
Hi - noticed that several sellers on Ebay are selling a Microsoft Launch Pack on Ebay that has SQL Server 2005 Standard Edition. Many of these are selling for really really cheap Have been told by one seller that it is a fully legal and legitimate ...
newbie openquery question
arch -
14 Jan 2006 7:32 AM - 7 messages
How do I use openquery to create a table in an oracle database. Any sql string that I pass thru fails as it doesn't return any rows. ...
Using MSDN version of SQL Server 2005
imarchenko -
14 Jan 2006 2:59 AM - 5 messages
Hello! We are planning to install MSDN version of SQL Server 2005 64 bit (Enteprise Edition) on Windows 2003 64 bit on our Production server initially and later on purchase/upgrade MSDN to Commersial version. I was ...
how to: profiling db & memory usage
usenetjb -
14 Jan 2006 2:07 AM - 8 messages
im a dba newbie, sql server 2000 sp3a on win2k server. database hums along around 350MB for a couple of days, then today all of a sudden sometime between 12pm and 8pm something caused mem usage to go to around 750MB. ...
Backups and Backup Devices in SQL2005
Chris Wood -
13 Jan 2006 10:04 PM - 2 messages
Hi, Credentials are needed to access resources outside of SQL. Is a backup and/or backup device regarded as a resource outside of SQL? Do I need to create a credential to use a backup and/or backup device? Thanks ...
Date conversion error on 2005
Amit -
13 Jan 2006 9:20 PM - 2 messages
Getting following error on 2005 on a query that works fine on 2000: --------------------------------------------------------------- Msg 241, Level 16, State 1, Line 1 Conversion failed when converting datetime from character string. ---------------------------------------------------------------- Here is the query: T_DATE column datatype is varchar(30) and the table does ...
SQL Mail system
Mike -
13 Jan 2006 8:53 PM - 4 messages
I keep getting the error "[355] The mail system failed to initialize" in the SQL Agent Log. I have tried everything I can think of including sending test emails which work fine but email notifications for job completion are not ...
Drop Primary Key Non-Cluster Index
Joe K. -
13 Jan 2006 8:47 PM - 2 messages
I have a SQL Server 2000 database that I need to drop the primary key that is a non-cluster index this has a foreign key. What is the correct syntax complete this task with the tables listed below. Table A ...
SQL Server Management Studio Express Edition
Dabbler -
13 Jan 2006 8:45 PM - 2 messages
can I use SQL Server Management Studio Express Edition CTP to manage remote SQL 2003 databases much like Enterprise manager (which I don't have)? Thanks ...
SQL Server 2005 and schema level security (Help!!)
Shabnam Gupta -
13 Jan 2006 7:08 PM - 6 messages
Hello Everyone, I am new to SQL server 2005 and I am not very familiar with how the permissions work. In SQL 200 I had a role setup and all the permissions were granted to the role and users were given the role. ...
Rollback a transaction log in standby server
KTN -
13 Jan 2006 6:36 PM - 2 messages
How do I rollback to a previous transaction log in a standby server? I applied 1st TLog and didn't find the data change issue. Then I continue with 2nd TLog and find the data issue. I would like to rollback to 1st TLog and ...
getting previous versions of a stored procedure
Pradeep Sundaram -
13 Jan 2006 6:34 PM - 2 messages
Hello All, We made a stupid mistake.We had overwritten some of our stored procedures accidentallyfrom an older script(dropped and recreated).Since this was a new database there are no back ups. This sounds extremely unlikely but is there a way to get the older ...
NSI DOUBLE TAKE vs VERITAS VOLUME REPLICATOR
Nick -
13 Jan 2006 6:13 PM - 7 messages
Hi everyone, I am looking at third party replication software from Veritas and NSI. Has anyonone used these? Any comments appreciated. Nick ...
difference between sql 2000 standard Edition and Enterprise Editio
xiaomei -
13 Jan 2006 4:51 PM - 6 messages
Hi, there, I hv a few question on SQL 2000 server: Currently we are runing SQL 2000 with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't want to upgrade to 2005 Eterprise Edition immediately due to other reason), can ...
Login failed for user 'xx'
renhai -
13 Jan 2006 4:51 PM - 2 messages
In the errorlog, we sometimes see the message: login failed for user 'xxx'. Question is: is there any procedure or query to find out who were trying to login with invalid pwd??? In oracle, it is simple. but not sure how SQL Server does?? ...
access denied to access a table in another server
mecn -
13 Jan 2006 4:32 PM - 7 messages
Hi, Here is the select stament: SELECT * FROM OPENROWSET('MSDASQL', 'DRIVER={SQL Server};SERVER=Testbox;UID=USersql;PWD=123456', Testdb.dbo.Testtable) Testtable WHERE (State= 'NY') When I run it in sql query analyzer, I got this error: Ad hoc access to OLE ...
Export Data Out without xp_cmdshell access
bluefish -
13 Jan 2006 4:31 PM - 2 messages
Hi, One of the development team is testing sp's that need to exporting out data as txt files. We do not like to grant execute access to 'xp_cmdshell' due to any number of things that can be done through this in Operatind system. ...
Full-text search across multiple tables
John -
13 Jan 2006 3:51 PM - 2 messages
Hello, We are developing an application against an MS SQL Server 2000 database which requires that we implement full-text searching across columns in multiple tables. The research that we have conducted seems to indicate that this is not directly possible within SQL Server 2000. And we can ...
sp_spaceused vs Enterprise Manager
Kamal Hassan -
13 Jan 2006 3:42 PM - 5 messages
One of the production database show following info when sp_spaceused run against it reserved data index_size unused ...
Try this one - is this a bug in SQL Server?
EA -
13 Jan 2006 3:01 PM - 8 messages
Try this one in the pubs database: use Pubs GO select count(*) from authors where au_id in (select au_id from discounts) GO Do you see anything that it does not make sense? The au_id field does not exist in the discounts table and SQL does not even throw an error ...
Longest row in a table...please help...
almurph -
13 Jan 2006 2:46 PM - 3 messages
Folks, Can you help me. I have a given database with a table in it. The table has several columns in it. How do I find the longest row in all of the tables? By longest I am referring to number of characters. ...
History rows
mecn -
13 Jan 2006 2:43 PM - 2 messages
I have job history for other jobs in the same server ...
Adding 2nd instance of SQL
Bad Beagle -
13 Jan 2006 2:29 PM - 5 messages
I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please clarify a few things for me? 1. Can this be done during productions hours - does it requre a reboot? 2. Does it actually install another full version of SQL - I only have a CD ...
SQL2k server Job history
mecn -
13 Jan 2006 2:19 PM - 5 messages
hi all I have a job that backup data. First time I ran for test and I saw the job history sucessful. that job scheduled runs every night. Now I don't don't see history anymore.---- there is no history info for this job. ...
Uninstalling SMS broke SQL
Jeff -
13 Jan 2006 2:08 PM - 4 messages
I made an error while uninstalling our SMS Site. Call it a case of too many mouse clicks, but in selecting the option to "Delete SMS Database" it broke the SQL connection to the other databases installed on the ...
Define FK over DB boundaries
Christian Havel -
13 Jan 2006 10:59 AM - 7 messages
Hi, is it possible to assign a foreign key from DB1 to a primary key from DB2? Thanks Christian ...
Questions on triggers and when they fire...
weegee -
13 Jan 2006 10:55 AM - 3 messages
I have a stored proc that does something like 'Update table1 set a = 'b' where c = 'd'' That works fine, no probs and updates multiple records in table1. The problem I have is with the Update trigger. It only seems to fire ...
SQL and Exchange server on same Workstation ?
Michael Bauer -
13 Jan 2006 10:05 AM - 8 messages
Hello, as far as I know, Microsoft prohibits SQL Server and Exchange Server both running on the same Workstation because both systems have sophisticated memory access technics that could make problems. Can anybody tell me a link where Microsoft writes about this fact and ...
Index -Pls Help-
Dil -
13 Jan 2006 9:54 AM - 4 messages
hi I have used the following query for checking whether an index is existing or not SELECT name FROM sysindexes WHERE name = 'TESTINDEX' This will return all indexes name 'TESTINDEX' if the database contains 10 indexes named as 'testindex' it will show ...
DBCC CHECKDB error
brnayak26 -
13 Jan 2006 8:25 AM - 5 messages
I can't drop tables anymore. I can do all other operations, like, create table ,insert/add/delete rows. My application creates and drops temporary table frequently, now i have quite many temp tables. I am getting this error since a week. if i use Enterprise manager to drop ...
not able to shrink transaction log file
firmRobin -
13 Jan 2006 7:38 AM - 3 messages
Hi I am a beginner working with MS SQL server 2000. Currently I am facing a problem where in my trasaction log file grows to a very huge value during particular time during night. The database is a back end of a Mcafee Application, E-Policy Orchestrator. ...
The file on device 'tape' is not a valid Microsoft Tape Format backup set.
spp -
13 Jan 2006 6:04 AM - 2 messages
When I try to restore a database from a tape backup I receive "The file on device '%ls' is not a valid Microsoft Tape Format backup set." I found this article at [link] but I have ...
Change the owner of Model database
AussieBri -
13 Jan 2006 6:01 AM - 2 messages
Hi We have a model database that is owned by someone who has left the company. i would like to change the owner but don't seem to be able to. sp_changedbowner won't let me. We have come up with two solutions that I would like to get some comments ...
Journal table for a database
Senthilkumar -
13 Jan 2006 5:38 AM - 5 messages
Hi, I am using a SQL Server 2000 database with a VB.net program and uses Integerated security. I want to log all the changes made to any table data(whether addition, deletion, updation) to a single table by all the ...
SQL Server 2000 encounter Sort Failure (Error 1501)
Eric Fung -
13 Jan 2006 5:15 AM - 5 messages
Dear Sir / Madam, We have seen the following event on Application Log, Error: 1501, Severity: 20, State: 1 Sort failure. The same error could be found on SQL Server Log at the same time, but no other additional entries is found. ...
Very simple stupid aggregate question
Prospero via SQLMonster.com -
13 Jan 2006 5:04 AM - 7 messages
I dont get the way SQL does aggregates its seems so clumsy... I just want to know a simple way to do something ridiculously simple... say i have some table with employeeID, name, city, salary I wanna find the highest paid employee per city. ...
MY DB starts Slowly.
cdmcdm2003 -
13 Jan 2006 1:09 AM - 2 messages
when restarting my windows 2000 server after log on it takes about 2 hours for my Sqlserver 2000 DB to fully start. It used to take less than a minute. any ideas? i already use Command (DBCC) check my DB,but not find any Errors. ...
reclaiming physical space after shrinking the log file
KM -
13 Jan 2006 12:57 AM - 3 messages
How can I reclaim back space after shrinking the <databasename>_log file? I backup my log file, then shrink it. I see it is only using less than 20% space but it is holding on to the physical space. I see this command DBCC ...
Help needed on Full text Search
Srinivas Kollipara -
13 Jan 2006 12:05 AM - 2 messages
Hello, we got a requirement where i hvae to implement a full text search in SQL Server 2000/2005. Can some one help me Where/How to start ? Any links for the articles is also good. Thanks in Advance Srinivas ...
Re: SQL 2005 Not found sysproperties
Netzarim -
12 Jan 2006 11:36 PM - 2 messages
There are applications, ie. SMS 2003, which reference tables such as 'sysobjects' and others during setup that now fail during install because these tables nolonger exist. Are there tools or SQL scripts that will recreate these tables under SQL 2005? and if so, would the that be sufficient? ...
SQL Server Log Question.
BobG -
12 Jan 2006 11:33 PM - 2 messages
I am fairly new to SQL Server Database administration. Yesterday someone altered a table with over a million rows. They deleted all but one column (about 50 columns). Our security is kind of loose. There are many ways to access the database, but only a few ways to alter the table so radically. ...
SQL 7.0
BrianMultilLanguage -
12 Jan 2006 10:50 PM - 2 messages
Is there a paper on moving a DB from one server to another. SQL 7.0 Thanks ...
Advanced Sql-Shape Query - Help
doar123 -
12 Jan 2006 9:47 PM - 3 messages
Hi, This is my basic sql shape query: ------------------------------------------------------------ SHAPE {select * from tbl1} APPEND({SELECT * FROM tbl2 where field1=1} AS RS2 RELATE field TO field) ------------------------------------------------------------ With this query i get a RecordSet (RS1), who handle all the records from table tbl1, and a secondary RecordSet (RS2) who handle all the ...
How to disable Named Pipes?
ChrisR -
12 Jan 2006 9:47 PM - 2 messages
Im experiencing a problem like this: [link] Im using SQL2K, SP3(he doesnt say which version of SQL). This guy found relief by removing Named Pipes. I dont understand how he was able to do it ...
using email service with dts package-error
Paul -
12 Jan 2006 9:25 PM - 7 messages
Hi I have a dts package and everything works except the email section. I get the error, Microsoft dts package, MAPI returned an error. Does not specify what the error is, just wondering if anyone has any ideas? The same package ...
horizontal partitioning
Jonny -
12 Jan 2006 8:28 PM - 4 messages
Hi Does anyone know of any good resources for learning how best to partition my data using SQL Server 2000? A resource that has examples on how to do this would be great. Also any resources for bulk moving the data between the ...
Moving Transaction logs to different spindle or directory
David -
12 Jan 2006 6:52 PM - 2 messages
Hi there, I have several databases running on production and I need to move transaction log files to different directory or spindle. What is the best way of doing it for many databases? I am concern about the downtime of these databases. Any trick to avoid the ...
Dividing in a view: 1 or 0
Chris Allison -
12 Jan 2006 6:29 PM - 4 messages
Hello, I am having, what seems to me as the oddest problem in SQL. I have created a view based on two tables, the two key columns in these tables are integers (quantity) what I am trying to do in this table is divide ...
Connecting to SQL Server with an alias
Chris Newby -
12 Jan 2006 5:58 PM - 3 messages
We have a soon-to-be legacy Sql Server called X. We have several queries on various other servers configured to talk to X thru a linked server that go something like: SELECT [columnName] FROM [X].[DBName].[dbo].[TableName] X will now be hosted on a new machine called Y. ...
SQL Query...........
John Smith -
12 Jan 2006 5:47 PM - 5 messages
SQL Query.. Here is my table "T1" with two fields. LoginDate à will have date and time stamp. LogoutDate à will have date (No time stamp). How to write the query to get the following result? # of records where LoginDate = LogoutDate. ...
Merging db servers, upgrading SQL version, downgrading edition
ToeJam -
12 Jan 2006 5:45 PM - 4 messages
I have a site with two servers. ServerA is running SQL 7.0 Entp. Ed. and ServerB is running SQL 7.0 Std. Ed. We want to combine all the user databases over to ServerA. We also want to upgrade ServerA to SQL 2000 but ...
Problem Viewing SQL2000 Tables Definition chm
Chris Wood -
12 Jan 2006 5:13 PM - 5 messages
Hi, I have the systabl.chm compiled HTML help file from the Resource Kit. I was able to view the table definitions before the MS06-001 problem surfaced. Now I just get an Action cancelled screen saying Internet Explorer was unable to ...
records with <NULL> aren't returned?
Eych -
12 Jan 2006 5:01 PM - 4 messages
I have a table (TempTable) with one field (Field1) and three records: 2 3 <NULL> if I do " Select * from TempTable where Field1 <> '2' " I only get returned : 3 why didn't the <NULL> record show up? Can anything be done to the ...
MS SQL 6 yes 6
Mike -
12 Jan 2006 4:52 PM - 5 messages
Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database? We have a 6 running that can't be upgraded and now it's in need of some TLC. Mike ...
Can't start SQL Server after renaming the server
Leon Shargorodsky -
12 Jan 2006 4:21 PM - 2 messages
I can't start SQL Server after my Windows 2003 server has been renamed. Do I have to reinstall SQL in order to rename it? Thank you for your help! Leon ...
SQL memory
Venedict -
12 Jan 2006 4:11 PM - 4 messages
Hi All, I have a client having 2 same server which is Proliant DL760 G2, 1 is 8 way Xeon 3GHz with 12GB RAM another is 8 way 2.2GHz with 14GB RAM. Both install with SQL 2K Ent Edition and SP3a and allocate 80% of RAM to SQL with AWE ...
Tricky Trigger
David -
12 Jan 2006 4:05 PM - 4 messages
Hi, I want to write an UPDATE trigger on TABLE_A and lets say it has 3 columns Col1 (Identity), Col2, Col3. The logic is like if Col3's value is updated and Col1 value is 5, update Col3 with value "X" (This value can be retrieved from ...
Question regarding Pubs and Northwind
Joresm -
12 Jan 2006 3:51 PM - 2 messages
Hello all, I have been asked this question and need to answer it. would the removal of pubs and northwind DBs from SQL2000 have an adverse effect on upgrade to SQL 2005? I would appreciate an answer. Regards, Joresm ...
Index Performance Monitor Counter
Joe K. -
12 Jan 2006 3:23 PM - 2 messages
I have a SQL Server 2000 database that I have clean up duplicates indexes and numerous other unneeded indexes. What are good performance monitor counters to show the database running better without these indexes? ...
how to turn off empty XML element feature
chacha -
12 Jan 2006 3:21 PM - 2 messages
Basicly in my file, there are some empty fields but I want them enclosed in a XML file with empty element content instead of an empty element. e.g. I insert a record into a table, CREATE TABLE ( C1 VARCHAR(10), C2 XML); ...
please - limit on # of databases - large number of databases - man
out of office -
12 Jan 2006 2:08 PM - 2 messages
I hear the limit of databases is over 37,000 but all over Microsofts site they dont recommend going over 1500 databases per artical 316749. This artical is close to our problem and we will be testing the -g option ...
IO Stress Tool like SQLIOStress or Database Hammer
Luis -
12 Jan 2006 1:31 PM - 2 messages
Hi, Could anyone indicate a good tool that perform IO Stress with SQL 2005 over 64-bit plataform? SQLIOStress isn´t fully compatible with that and couldn´t find anything about Database Hammer. Thank you! ...
Taskbar Icon on SQL 2005
MV -
12 Jan 2006 1:24 PM - 4 messages
Hi, is there a way to got the taskbar SQL Icon (sqlmangr.exe) on SQL 2005 ? Thanks ...
70-228 Exam Book?
Trying2Learn -
12 Jan 2006 1:02 PM - 2 messages
Hello Can anyone suggest a good book for preparing 70-228? I found this MCSA/MCSE/MCDBA: SQL Server 2000 Administration Study Guide (70-228) by Sybex pub. But I am not sure about this really. Someone was really praising Wrox - Professional SQL Server 2000 Programming. I have no ...
Upsizing
Charles A. Lackman -
12 Jan 2006 10:15 AM - 2 messages
Hello, I have an access database that I am trying to upsize to MSDE. Everything works great except when the upsize takes place it does not transfer the data that is in the tables (only the structure). I do NOT have the wizard set to do only the structure, so it seems odd. ...
Pics/Clips insert/select from sql2000 table
Beau Peep -
12 Jan 2006 9:52 AM - 2 messages
Yo Guys, Need hlp in my probs. Am tryin to insert the pics/movies(clips any formats) in the sql2000 table. Have a table with a field Image. Me love to see any code workin of these. An get those pics/clips from the ...
Log File Size (SQL 2000)
Vensia -
12 Jan 2006 9:36 AM - 2 messages
Dear All, How to maintain the transaction log file size ? When I should use Restrict filegrowth or Unrestricted filegrowth ? How many MB shoud I setup for the log file size ? Thanks. Vensia ...
optimizing resource allocation
imad koussa -
12 Jan 2006 7:49 AM - 3 messages
Hi All, Some of the queries we are running are resource intensive which is impacting other users running other processes on the same SQL server. Is there a way to limit the time allocated to a query so it pauses after x seconds in order ...
Stored Procedures Permissions
Prasad -
12 Jan 2006 7:32 AM - 4 messages
Hi, This is for the SQL 2005 (Yukon) Server. Can anybody tell me what the permissions "References" means on the Stored Procedure. Even if it is not possible to assign the "References" permission ...
SQL Server, .Net application and Windows 2003 on VMWare
Lonn -
12 Jan 2006 3:44 AM - 4 messages
Hi, I have a .Net application (.exe) that connects to SQL Server 2000 using the System.Data.SQLClient object. The application runs on Windows 2003 server on VMWare. SQL Server is also installed on this Windows 2003 server. ...
SQL Server 2005 Standard to Enterprise
David -
12 Jan 2006 12:57 AM - 3 messages
All How do I go about upgrading SQL Server 2005 Standard Edition to SQL Server 2005 Enterprise Edition. Thanks ...
Local admin needed for DBA???
ChrisR -
11 Jan 2006 11:54 PM - 3 messages
Its been proposed at my company that the DBA's no longer have WINNT Admin rights to the SQL Servers. I don't know that Im totally opposed to it as long as I can get my job done. What things would a DBA not be able to do if he was ...
sp_dboption 'auto update statistics' and sp_updatestats
tjanders7 -
11 Jan 2006 11:01 PM - 3 messages
Does turning on the database option 'auto update statistics' immediately cause statistics to be updated if they are over their threshold? What triggers AutoStats to run if you turn the option back on when statistics are already over their threshold? ...
Delete
Mathew -
11 Jan 2006 10:52 PM - 4 messages
Hello, I want to delete a record from one of my tables. When i delete it, it is deleted, but when i close and open it, it's still there. why? It just happens to this table. The other tables are ok. ...
Lost SQL 2005 management capabilities after detaching a DB
Gaetan -
11 Jan 2006 10:24 PM - 10 messages
I detached a user database to move it to a different drive. Problems started when I tried to attach the moved database. The first time I tried to perform an "Attach..." function, SQL Server Management Studio generated this error message: ...
SET Statement on a Linked Server (SQL 2005)
Paul S. Waters -
11 Jan 2006 10:23 PM - 7 messages
Hello, I have a linked server to and Ingres Database via the OLD DB provider for ODBC. I can create queries to select data from tables but I do not know how or if I can send the ingres database a SET command. I need to send it 'set ...
I don't have Sql Server at home. Is a trial version the best alternative?
BLACKDOG157 -
11 Jan 2006 10:13 PM - 6 messages
I don't have Sql Server yet. I'd like to learn it at home before I apply to businesses that use it. I see that there is a trial version of sql server 2005 that lasts 180 days. But are there any other ways ...
Profiler Trace ID
David -
11 Jan 2006 9:40 PM - 4 messages
I want to check the TraceID from the system tables like the object ID we can check from sysobjects table. Is there any similar table used to store TraceID's? Thanks ...
NULL
Yosh -
11 Jan 2006 9:01 PM - 3 messages
This is bad but I've forgotten how. How do you insert a null value in a column using the keyboard when you have a table opened in SQL Enterprise Manager? ...
Need help with error when starting sql server
jaialai technology -
11 Jan 2006 8:53 PM - 3 messages
This is what I see inthe event viewer: 17204 : FCB::Open failed: Could not open device D:\Program Files\Microsoft SQL Server\MSSQL\data\model.mdf for virtual device number (VDN) 1. Now, the real annoying thing is that I do not have a "D" drive! ...
Transaction Logs
Eric Hughes -
11 Jan 2006 8:24 PM - 3 messages
Hi There. I have a database server that has gone pretty much unadministrated for some time now. The transaction logs on this server are very huge over 400 gig total. I do nightly full backups of the databases every night. What ...
SP4 AWE hotfix not installing.
DTully -
11 Jan 2006 8:21 PM - 2 messages
I installed SP4 on a production DB cluster server (W2K3 SP1, SQL 2000, 32GB RAM). After the install I tried to apply the AWE hotfix, but after decompressing, I received a message stating 'No Qualifying Products - This machine does not have a product that matches this installation package'. ...
msdb's sysjobs tables
Cathy Boehm -
11 Jan 2006 7:32 PM - 7 messages
Please list the cases when the contents of sysjobhistory table would be deleted. thanks ...
SQL 6.5 tasks
Mintu -
11 Jan 2006 6:34 PM - 3 messages
Recently I noticed that tasks on sql 6.5 server are not executing at scheduled time. Tasks are enabled and scheduled but they don't run at that time. They don't fail or anything but don't even start executing. I ran ...
help
peter -
11 Jan 2006 6:22 PM - 2 messages
I am runnig query select count(*) from A I like to display the count in following format. For ex. If the count is 45 then it should display 000045 If the count is 145 then it should display 000145 If the count is 5 then it should display 000005 ...
back up job not backing up properly?
KBuser -
11 Jan 2006 5:57 PM - 3 messages
I had created 7 jobs to back up our database every day, the files were created, and the modified dates have been updating on the files that were created, so I never bothered to check the data, as it was only a ...
Upgrade from 8.00760 to 8.00.859
MittyKom -
11 Jan 2006 5:09 PM - 3 messages
Hi All What do i need to upgrade my sql server from version 8.00760 to 8.00.859? Thank you. ...
Subject line - sql agent notification
JS -
11 Jan 2006 5:03 PM - 2 messages
Is it possible to configure the subject line generated by SQL Server Agent for job notifications? We would like to be able to start the subject line with either the SUCCESS or FAILURE of the job. Please let me know if you ...
Upgrade SQL 2000 Personal to SQL 2000 Standard edition
kshv -
11 Jan 2006 4:26 PM - 3 messages
Hi I having problem with upgrading from SQL 2000 Personal to SQL 2000 Standard edition. When I try to upgrade the existing installation the following two options are masked and doesn't allow me to choose the option to upgrade. ...
How to deploy SQLProject from VS2005
GS -
11 Jan 2006 4:25 PM - 2 messages
Hello, According to documentation I'm supposed to be able to deploy SQL project directly from VS2005. I don't have Either Build<project name> under Build menu, neither I have Deploy <project name> for my SQL project. ...
User SQL CAL like TS User CAL?
Chris -
11 Jan 2006 4:07 PM - 2 messages
Is the User SQL CAL similiar to the Terminal Services per User CAL where I can have 80 users but only 20 can connect at a time because of having 20 TS CALs? Or is the User SQL CAL like the Server CAL where I have to have 80 ...
auto logout in sql server
sharman -
11 Jan 2006 3:57 PM - 3 messages
Hi, Is there a auto logout feature in SQL Server? If a user is logged on to the server through an application and is not using the application, is there a way to force a logoff after 15 or 30 minutes? Thanks. ...
DateTime question
BetaD -
11 Jan 2006 3:50 PM - 4 messages
I'm trying to update a datetime field in my database with the current date and time. The following command inserts the date as 1/13/06 when most systems recognize 38728 as 1/11/06. Why does sql server 2005 ...
Linked vs. Remote Servers
Jay Bukstein -
11 Jan 2006 3:46 PM - 3 messages
My question is two fold. One, whats the difference between a linked SQL server vs. a Remote SQL server? Two, From server A I set up a Linked server to B, and on server A Query analyzer I run the following ...
Wait Resource Value?
Richard -
11 Jan 2006 3:32 PM - 3 messages
I have the following items in my process info report. I am investigating these processes, because they are running slow at random intervals. I have done a little resource on the PAGEIOLATCH_SH wait type but, I do not ...
2005 inline table function produce incorrect resultset than 2000
bLad3 -
11 Jan 2006 3:11 PM - 7 messages
OK....this all works in 2000. I have wondered why return results were different in an inline table function (run on the same set of data) in 2005 than 2000. The function is the same...a parametized function with a no join select on a table. The function ...
SRS admin skills.
ChrisR -
11 Jan 2006 3:00 PM - 3 messages
Our organization has plenty of folks that know how to create reports and upload them into production using SQL Reporting Services 2000. However, nobody has the skills of implementing security and setting up an enterprise solution. These are they skills that I need a crash course in. I was hoping ...
Restoring Master Db
MittyKom -
11 Jan 2006 2:50 PM - 2 messages
Hi All What are the steps in restoring a master database?Thanx in advance ...
|
|||||||||||||||||||||||