|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Probably easy - get top 2 for group
chip_donor -
12 Nov 2005 11:50 PM - 9 messages
I'm new to the group and fairly new to non-trivial SQL queries, so here goes... This is probably very easy to do, but I'm stumped. I have a table with categories and any number of values for the ...
Probably easier than I think - get difference of top two for group
roger.osborn@mindspring.com -
12 Nov 2005 11:45 PM - 2 messages
I'm new to the group and fairly new to non-trivial SQL queries, so here goes... This is probably very easy to do, but I'm stumped. I have a table with categories and any number of values for the ...
tempdb filling up - sql2000
Tito Madrid -
12 Nov 2005 6:55 PM - 5 messages
Hi all - We have a turnkey server running win2k (sp4), and sql2000 (sp3) and a software package called workforce timekeeper from Kronos. The Kronos app is running fine, but the tempdb db keeps filling up and basically shutting down the system. One of the problems is that the tempdb ...
SQL 2005 - views and Order By
Sascha Andres -
12 Nov 2005 6:36 PM - 6 messages
Hi, I updated an SQL Server 2000 for testing purposes to SQL 2005. When I started the application that uses the database I noticed some changes, that in my oppinion shouldn't occur. I think one of the changes fit best in this newsgrou, because I ...
Getting Identity back
Tina -
12 Nov 2005 4:59 PM - 6 messages
in my VB.NET program, when I do the following, how can I get the value of the primary key back which is an Identity column? Thanks, T connPO.Open() Dim strSQL As String strSQL = "INSERT INTO Orders " & _ ...
Index Wizard
Joe K. -
12 Nov 2005 2:45 PM - 2 messages
I created SQL Profiler trace that was input into the Index Tuning Wizard. I selected the option to take away the present indexes. The output recommendation had 6 indexes that should be created. Are these recommended indexes should they be primary keys that are cluster ...
automatical calculation of a field value
Jan Rösner -
12 Nov 2005 12:43 PM - 2 messages
Hi All, I have a table "AggregatedSales" which has a column called "AggregatedSales.YearSum". This column should contain a sum which can be derived directly from another table called "Sales" by summing up all values of "Sales.Price" WHERE "Sales.Year" = 2005. ...
How to restore Values to Table based on some Query
vinoth -
12 Nov 2005 12:19 PM - 6 messages
Hi, I have a table called A and another Table Called B. A table has the following Column and Values ID One Two Three ...
SQL srvr 2005 standard ed. parallel scan
Derk Jan -
12 Nov 2005 12:05 PM - 5 messages
Hi, Does anyone know if SQL 2005 Standard edition supports parallel scans (multiple threads) of queries wich data span more -physical- IO devices? Or is this feature availible only in enterprise edition (like SQL 2000). thanks, Derk Jan ...
sql2005
lima -
12 Nov 2005 6:32 AM - 3 messages
I have created a number of databases in SQL2005 beta versions. I have just installed the new release and I cannot restore my old databases. I get an error that says that my version is too old. ow can I upgrade my databases to ...
Can't Run Query Analyzer
Mike Kelly -
12 Nov 2005 4:39 AM - 2 messages
When trying to access Query Analyzer from Enterprise Manager, I receive the error, "The specified file was not found". I don't know what happened, as it was working fine yesterday, and I've made no changes to the system in the ...
Suport for Microsoft Suite of Server Products
Larry Bird -
12 Nov 2005 1:13 AM - 3 messages
Not that Microsoft has releases SQL 2005 server. Does it currently support the following Microsoft products: Indentity Server SharePoint Services SharePoint Server ISA 2004 MOM 2005 BizTalk 2004 Content Management Server Project Server And any Microsoft server product that I may have missed. Is it just a ...
Backup to disk
tshad -
12 Nov 2005 12:51 AM - 2 messages
I am setting up my backup strategy and want to do Full backups at night (12:00 am) and hourly incremental backups to disk. The problem is the incrementals just keep getting appended to the same data file *.bak. If I find that our data is corrupted after about 2:00 pm and want to ...
SQL Server Port for Named Instance
Jason -
12 Nov 2005 12:15 AM - 2 messages
I would like to install SQL Server 2005 as a named instance on a server with SQL Server 2000 installed. From my understanding, I have to assign a different port number (other than 1433) for the named instance. I would like to know when I connect to the SQL Server 2005 named instance ...
Operator precedence bug in SQL Server 2000?
martijn.vels -
12 Nov 2005 12:05 AM - 5 messages
Consider the following expression: SELECT 41 % 17 % 5 Returns: 2 This simply follows the rules of precedence: 1) Unary operators 2) Left to right per ranl As all modulo operators are equal rank, it will be simply evaluated left to right ...
Backup display
tshad -
11 Nov 2005 11:58 PM - 2 messages
I created some backups for my databases and they show in the Enterprise Jobs as Uncategorized [local]. All the Maintenance Plans show as Database Maintenance. I have about 10 of them and you can't tell which is which without going into ...
SQL Error Log is not logging events properly
Andy S. -
11 Nov 2005 10:52 PM - 2 messages
I have a server where the sql error log is constantly missing events. Usually you see when processes were killed, backups, server reboots, etc. I have a SQL 2000 SP 3a server that is logging when databases start, a few of ...
control the percentage of processor used by SQL server
hongo32 -
11 Nov 2005 9:03 PM - 4 messages
exists a form to control the percentage of processor used by SQL server? for example, not use more than 60% percent. ...
INSERT INTO
Roy Gourgi -
11 Nov 2005 9:02 PM - 3 messages
Hi, I am trying to insert a row but it is not working. My code is below. TIA Roy using System; using System.Data; using System.Data.Common; using System.Data.SqlClient; using System.Data.SqlTypes; using System.Text; namespace testing ...
Scheduling PSSDIAG
chinn -
11 Nov 2005 8:55 PM - 2 messages
Hello, I got this PSSDIAG from MS and i want to schedule that way i need not be the on the machine or lock the machine. Is there a way i can schedule this so that i start and stop the schedule so ...
DBCC SHOW_STATISTICS
Joe K. -
11 Nov 2005 8:17 PM - 2 messages
I would like detail information that goes along with DBCC SHOW_STATISTICS within SQL Server 2000. I am trying compare indexes within a table to see which indexes were used the most. Thanks, ...
Database Relationship
betrek -
11 Nov 2005 8:12 PM - 3 messages
Hi all, Where can I see the Table relationship in Enterprise Manager. I see all Tables but to run some query using two or more tables I need to know which table is connected with that particular table. Can someone help me. ...
No Differential Backup on Master DB
sasiraj -
11 Nov 2005 7:39 PM - 2 messages
Hi, Can someone plzz explain the below reason "Differential backups are not allowed for the master database since they require that complete backups be applied without recovery as the first step. When restoring the master database, restore without recovery is not allowed." ...
SQL Server 2005 - Cannot connect
Amos Soma -
11 Nov 2005 7:23 PM - 2 messages
I converted a 2000 database to 2005, and it's sitting on a remote server. When I attempt to connect to it from my laptop using Management Studio, I can connect without problem. However, if I try to connect to it from an ...
locks
Janos Horanszky -
11 Nov 2005 5:51 PM - 2 messages
What WaitTypes 0x2, 520, 1028 mean? Where can I get a full list of values and explanations? What I have so far is this: Case WaitType When 0x0 Then ' ' When 0x0005 Then 'Exclusive Page Lock' ...
cache in sql server 2000
byteman -
11 Nov 2005 5:50 PM - 8 messages
There is a command or option that let me change or manipulate the size of procedure and data cache in order to obtain better performance ratios in sql server 2000? ...
Table Properties
Paul Bergson -
11 Nov 2005 4:41 PM - 3 messages
Is there a way to describe all the properties within the table via an sql command in Query Analyzer? I'm sure I have done it before (Other than using table properties in Enterprise Manager). ...
List all Foreign Keys, Primary Keys, Indexes
Craig -
11 Nov 2005 4:22 PM - 2 messages
With Microsoft SQL Server is there a way to list all Foreign Keys, Primary Keys, Indexes etc. in addition to the database diagrams? Thanks ...
SAN upgrade causing PAGEIOLATCH_EX and PAGEIOLATCH_SH?
bourgon -
11 Nov 2005 4:15 PM - 4 messages
We recently had our SAN upgraded. In theory, this was brilliant. We moved from a gigantic raid-5 partition to an near-ideal situation: RAID-10, RAID-1, RAID-5, etc. Moved databases around to lower contention, etc, etc. ...
Change in Job Execution - SQL Server 2005?
Amos Soma -
11 Nov 2005 2:47 PM - 3 messages
I just converted a SQL Server 2000 database to 2005. I have a job whose only step does the following: Declare @Command char(240) Set @Command = '\SDBS\Scheduler\Scheduler.Exe ' + Convert(char(50),Convert(uniqueidentifier,[JOBID])) + ' ' + (Select ...
No connection limitation with SQL Express 2005?
the friendly display name -
11 Nov 2005 1:53 PM - 4 messages
MSDE had the limitation of 25 concurrent connections. It seems that SQL Express 2005 doesn't have this limitation. Is that correct? Does Express support as many connections as the "full" SQL 2005 server? ...
SQL Server 2005 Express
Nedi -
11 Nov 2005 1:37 PM - 4 messages
I have just installed SQL Server 2005 Express and SQL Server Management Studio Express (SSMSE). I have two problems: a) after installing SQL Server 2005 Books OnLine SSMSE doesn't start anymore b) using SSMSE I try to attach a Database created with MSDE 2000, but I get ...
Database Snapshot (SQL Server 2005)
Leila -
11 Nov 2005 11:59 AM - 5 messages
Hi, ------- Sorry for posting my question in this group. Isn't Micsrosoft going to create new forums for SQL2K5? ------- BOL states that the snapshot file(sparse file) is small when it is created, and gradually grows. But I tried on my databases (even big ones) and its ...
x64 Opteron running SQL Server 2005 in 32-bit?
Jacob_I -
11 Nov 2005 11:26 AM - 4 messages
Hi, I installed SQL Server 2005 Ent. on an x64 AMD Hammer server running Windows 2003 Server Std. x64 ed. When I open SQL Server configuration Manager and view advanced properties of the SQL Server (MSSQLSERVER) then the 'Running under 64 bit OS'-parameter is ...
When will SQL Server 7.0 support expire?
Aya Abd El-Wahab -
11 Nov 2005 11:04 AM - 2 messages
Just a question regarding the proposed end of support for SQL Server 7.0. I had heard that it was 31st December 2005.... ...
Hidden Databases?
Joachim Hofmann -
11 Nov 2005 10:47 AM - 2 messages
Hello, on an instances log I see entrys which say that Databases "model4IDR" and "master4IDR" are started. But through E.M. or sp_helpdb I don't see such databases, among other things only the normal system databases. What could be that? ...
New SQL Server Install Advice
Skc -
11 Nov 2005 9:26 AM - 3 messages
I have a new Dell PowerEdge 2800 running windows 2003. I have 2 RAID containers as the machine has a PERC 4 controller. The machine has x2 73GB SCSI and x4 146GB SCSI HDD. Container 1 ------------- The OS C drive (partition of 12GB) is in RAID 1 and so is E drive which has ...
Password does not meet Windows policy requirements 2005
Paul -
11 Nov 2005 9:00 AM - 3 messages
I have been given the task to see if our software will work against SQL Server 2005:- XP Pro installed on a Virtual PC SQL Server 2005 Standard Edition Installed Mixed mode Security Check policy set to off Installation of 2005 was successful and no error reported in the logs. ...
Upgrade of SQL Server 2000 DB to SQL Server 2005 DB
Jason -
11 Nov 2005 8:11 AM - 7 messages
I have read in the newsgroup that someone has suggested that when we detach a SQL Server 2000 DB and attach it to a SQL Server 2005 Server, it will be converted to SQL Server 2005 Server (Level 90). However, someone says that ...
SQL Server 2005 Forum ?
Jason -
11 Nov 2005 8:03 AM - 3 messages
A number of MVPs advised us to ask questions re SQL Server 2005 in this newsgroup. However, I find that there are MS msdn discussion forum at [link] ...
schedule email function
Fox newbiew -
11 Nov 2005 6:11 AM - 10 messages
Hi all, I am looking for scripts or method could use sql sever periodaically send out emails to alert users according to the particular time log setting. Thx in advance, Fox Newbiew ...
SQL 2005 CLR SP
Bobby Henningsen -
11 Nov 2005 5:34 AM - 4 messages
Hi there, i tried to post this in another group but it doesn't seem that anyone have a solution to my problem so I hope it's OK to try this group :)) I got the following CLR SP Made the following CLR SP : ...
Linked server error in SQL 2005 RTM
Quinn -
11 Nov 2005 5:27 AM - 7 messages
I have a stored procedure which inserts data into a temp table by calling another stored procedure via a linked server. It works fine under SQL 2000. However I'm getting the below error after upgrading to SQL 2005. Below is ...
dbcc shrink log file
Sal -
11 Nov 2005 3:12 AM - 4 messages
Hi: I just want to confirm that do we need to backup the database after using dbcc shrinkfile(log, )? I read somewhere that it invalidates the log sequence, therefore, we will not be able to apply transaction logs to last DB ...
sqlexpress specifying precision of numbers, floats
derek -
11 Nov 2005 1:52 AM - 2 messages
Hi, I want to export data from a table in SQL express to a text file in a rigid format. (The exported tect file will be fed as input to a FORTRAN program, therefore the rigid formatting requirements) space integer float with a precision of 8.4 ...
trigger between 2 databases
Jason Huang -
11 Nov 2005 1:43 AM - 6 messages
Hi, I have 2 databases DBInvoice and DBService. Each one has a table Dept. Can I create a trigger between DBInvoice and DBService, so the data in DBInvoice.Dept changed will also be changed in DBService.Dept? Thanks for help. ...
SQL Server notify application
jody.gelowitz -
11 Nov 2005 12:56 AM - 2 messages
Application setup: Program 1 (VB.NET): Monitors SQL Server 2000 and displays log and exception information from other programs Program {x} (VB.NET): Updates SQL Server 2000 with logging and exception information Currently, Program 1 is setup to poll SQL Server every 15 seconds for ...
detecting Identity in INFORMATION_SCHEMA
Tina -
11 Nov 2005 12:44 AM - 3 messages
I'm developing a SQL Utility program intended to work with multiple brands of database. Right now we just want to get it working with SQL Server. I am using INFORMATION_SCHEMA to get information on tables, columns, keys, ...
SQL Server 2005 Express
Yosh -
10 Nov 2005 11:43 PM - 2 messages
Is it possible to install SQL Server 2000 and SQL Server 2005 on the same pc without any problems? Thanks, Yosh ...
TCP/IP fails on SQL Server 2000 on Win2k3
Sam -
10 Nov 2005 11:10 PM - 2 messages
I have windows 2003, running SQL2k, SP4 installed. I had disabled TCP.IP for a while. Recently added it back, restarted the services. it doesnt seem to be running on 1433 (checked it using netstat -an). i see a UDP 1434, but thats about it. ...
Execution plan whackyness
Frank Rizzo -
10 Nov 2005 10:11 PM - 6 messages
Ok, I have this stored proc that does a lot of things and as of recently it runs really really slow, like 2 minutes (versus 7-8 seconds before). In an effort isolate the problem, I cut and pasted the stored proc ...
Upgrade from 2k to 2005?
Jason Chen -
10 Nov 2005 10:06 PM - 5 messages
I am wondering in the process of upgrade to SQL2005, if I detach a database from SQL 2k then copy and reattach to the SQL 2005 server. Would I get the full benefit of the SQL2005? My concern is that after copy over the database ...
massive update on a table of user
hongo32 -
10 Nov 2005 8:59 PM - 10 messages
hi, i'm train to find the best way to write a sp that update a table in a transactional system.... the table is goin to be consulted many time for second... while this happens, I need to update a lot of rows of the ...
PSSDIAG
Sylvain Nadeau -
10 Nov 2005 8:36 PM - 2 messages
Is there a problem with PSSDiag on a Windows 2003 SP1 server running SQL Server 2000 SP4 ? It seems to hang. The tool works perfectly on a Windows XP SP1 with SQL Server 2000 SP4. ...
Difficult Combining Rows queston...followup
jasonsgeiger -
10 Nov 2005 8:35 PM - 3 messages
Greetings, I'm working to combine rows based on a time window and I am hoping to be able to write a stored procedure to do this for me, rather than have parse through all this data in my program. I'm not very well versed ...
SQL2005 Enterprise "Oracle Replication"
Phyllis Yao -
10 Nov 2005 8:24 PM - 2 messages
Where can I get more information on this feature that's only available on Enterprise edition? Transactional replication with an Oracle database as a publisher [link] ...
Database History Info
LITO -
10 Nov 2005 8:03 PM - 2 messages
Is there a way in SQL Server to check when the database was deleted? ...
How long will a differential backup take?
bpettus -
10 Nov 2005 7:46 PM - 4 messages
How can I determine how long a differential backup will take to complete? I think reading the "differential change map" pages of the database would help, but I don't know how to do that or even if it is possible. ...
Triggers not working !
Sameer via SQLMonster.com -
10 Nov 2005 7:28 PM - 17 messages
Hello, I just need a confirmation of my diagnostics....... I'm trying to implement a trigger on a table but it doesn't work. After a lot of efforts and contemplation, I think the reason it doesn't work is because my database recovery model is set to 'Simple' and hence, this ...
SQL 2K vs SQL 2K5
James Jeffers -
10 Nov 2005 5:54 PM - 4 messages
In the 2K EM, we got a graphical view of the database as far as database size and free space in each of the data and log files. Does anyone know how or if that type of info is available in 2005? ...
Where do I download VS 2005 Express?
Roy Gourgi -
10 Nov 2005 5:45 PM - 2 messages
Hi, Where do I download the free edition of VS 2005 Express? Has anyone experienced problems with VS 2005 Express? TIA Roy ...
User CALs
tjfdownsouth -
10 Nov 2005 5:33 PM - 4 messages
I looked but I could not find an answer, is a user considered a connection or is it a logon to the network. I have an application that has 10 to 20 people access it throughout the day but no more than 2 or 3 in it at one time. If a ...
? : Preferred disk raid config when using SQL Server 2005
Listoff -
10 Nov 2005 5:06 PM - 4 messages
Hello all, If you are planning on installing SQL Server 2005 on a WIndows 2003 SP1 server, is there a "preferred" disk configuration that gives redundancy and fast performance? I was going to go hardware raid 5, but I fear ...
Stored Procedure Parameter Problem
the_kiddie98 -
10 Nov 2005 4:57 PM - 2 messages
Hi, I have a stored procedure which returns values from a table. I want to be able to pass it a parameter which it should ignore if it is 0 but include in the where clause if it is 1. ...
Filtering out bad phone numbers
Ray -
10 Nov 2005 4:49 PM - 3 messages
I am using SQL Server 2000 SP4 I am trying to filter bad phone numbers out of my results but I cannot quite get the syntex that I need. I have phone numbers like: ++ () - + () -3681 + () -8544 + () ? + () ? + () 0-+00-00 ...
SQL Server Agent
MS User -
10 Nov 2005 4:39 PM - 2 messages
SQL 2000 Today few of our SQL jobs failed with 'Performing Completion Actions' and couldn't re-start . I tried stop/start SQL SERVER AGENT , but the agent is in Starting status and never came back. Finally I was forced to reboot the server. ...
SQL Express 2005 Question
Yosh -
10 Nov 2005 4:22 PM - 2 messages
I've just installed SQL Express 2005. I am trying to connect to the server instance through the SQL Server Management Express Studio. When I click on the Server name, the local server instance is not found. When I type in (local)\sqlexpress or .\sqlexpress or ...
remap user to domain acct.
Corey Bunch -
10 Nov 2005 3:47 PM - 2 messages
In 2000, is there a way to remp a database user from a SQL login to a Windows login? For example. My name is John Doe. I've got a SQL login jdoe to server A. I've also got a Windows login to server A ...
RAID1 vs RAID5 for transaction log
TJT -
10 Nov 2005 3:30 PM - 4 messages
I was hoping that someone could point me to some good documentation on selecting an optimum RAID configuration. While performing heavy updates during upgrades - I've noticed dramatic performance difference between RAID 1 and RAID 5 for the transaction log. ...
Need help choosing Server Hardware
John -
10 Nov 2005 2:55 PM - 7 messages
Hi, I'm ussually just told what I will be working with, but today I was asked to choose the hardware myself. First off, it's a small company, so a $10,000 server is not an option. But ...
Bind message to a constraint check
valerie uzan -
10 Nov 2005 2:31 PM - 2 messages
I'm doing a migration form Sybase to Microsoft Sql Server 2005. On my sybase datbase, I have some check constrainst. Thos contraints are linked (sybase procedure sp_bindmsg) with specific messages in case that those constraint are not followed. Idon't know and don't find something equivalent on Sql Server. ...
Table update taking over 9 hours
Joe -
10 Nov 2005 2:19 PM - 5 messages
I've inherited a very nasty set of stored procedures that are supposed to form part of an ETL process. I started the ETL process yesterday and 16 hours later it’s still running. The code consists of a main control stored ...
SQL 2005 Dev. Management Studio cannot connect to 7.0 servers?
Whitey -
10 Nov 2005 2:05 PM - 4 messages
TITLE: Connect to Server ------------------------------ Cannot connect to (servernameremoved). ------------------------------ ADDITIONAL INFORMATION: This version of Microsoft SQL Server Management Studio can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (ConnectionDlg) ------------------------------ BUTTONS: OK ------------------------------ Our live server is still on 7. And it seems to have uninstalled Enterprise ...
required to only move data/log files to new SAN, best method?
peter walker -
10 Nov 2005 12:36 PM - 2 messages
Hi, our sql 2000 server is configured in such a way that the sql server resides on a box called Server_A, and has its data files present on a storage area network called SAN_OLD. Due to limited space, we have to move ...
Capsil experience?
vantageresources -
10 Nov 2005 12:11 PM - 2 messages
Any AS400 Developer out there have recent experience on Capsil? ...
Restore a basebase on sql server 2000 sp4 from a backup from sql server 2000 sp3
Server Applications -
10 Nov 2005 11:56 AM - 2 messages
Is this safe. or can it cause any problems. The reson I ask is because I see the following error "[DBNetlinb] connectioncheckfordata" when I execute (from query analyser or osql) Insert Into temptable select ... from [databasesource].source ... both databases running on the same server ...
CAL licenses - don't understand!
Tim P -
10 Nov 2005 10:51 AM - 4 messages
Hi I'm in the process of migrating from hosting web sites on a shared server and just buying SQL Server DBs when I need them, to a dedicated server which I have to administer. So now I need to buy a 'proper' copy of SQL Server as ...
[RFI] Sql Server 2k- Error Handling strategy
Uzy -
10 Nov 2005 10:45 AM - 3 messages
I am currently trying to put together a document that would outline the Error handling strategy for a SQL Server 2k based project. The solution is based on some DTS (mainly ActiveX scripts) but mostly Stored procedures are doing the bulk of the work. ...
Auditing on SQL-server.
ben brugman -
10 Nov 2005 10:03 AM - 3 messages
Hello Readers, I am looking for ways of auditing in SQL-server. Using Google I am a bit overwhelmed with solutions. At the moment we are looking at limited auditing, where the following has to be audited : user, date_time, some specific database mutations. ...
Can 2000 and 2005 coexist?
Ben Amada -
10 Nov 2005 9:04 AM - 3 messages
I need to manage a couple of SQL 2000 servers and a couple of 2005 servers from a single "admin" machine. I currently have just 2000 (server & client tools) installed on the admin machine. Is it possible to install (not ...
Null problem
weetat -
10 Nov 2005 8:20 AM - 3 messages
Hi all , I am using MicrosoftSQL 2000 server in Window 2000 Pro. I have problem update column "SEC_CARRIER" which allow NULL values . When execute sql below , it did not update SEC_CARRIER column at all . However if i added some value in the SEC_CARRIER manually then execute ...
Self Join Question!
CK -
10 Nov 2005 6:04 AM - 5 messages
Hi All, Sorry if it is a dumb question but it is quite tuff for me to find out. I have the following table create table Supply (MM varchar(6), Place varchar(4), WW int , Blg int) I have four rows in the table ...
How can I have a log of all SQL Server transactions ?
SQLBIz -
10 Nov 2005 5:39 AM - 3 messages
Hi guys ! Any body knows that how can i have a log of all SQL Server transactions ?? Thank's ...
Microsoft SQL-DMO(ODBC SQLState:42000)
John Smith -
10 Nov 2005 3:57 AM - 3 messages
I am getting the following error message in SQL 2K when I try to give database access to a login Id "LogInId1". ***************************************************** Microsoft SQL-DMO(ODBC SQLState:42000) Error 15023: User or role 'LogInId1' already exists in the current database. ...
Non-Cluster Index Primary Key
Joe K. -
10 Nov 2005 3:42 AM - 2 messages
I inherited a SQL Server 2000 database that has performance issues. I noticed the primary keys are set up as non-cluster indexes. By default the table primary key is created as cluster indexes. Could this cause a database performance problems if these are large tables and access ...
SQL 2005
Chad -
10 Nov 2005 3:16 AM - 5 messages
I just went to the MS VS 2005 Launch and got a free copy of SQL Server 2005 Std Edition. and I installed it. Stupid Question: Where the hell is the SQL Server Management Studio (the Entrerprise Manager replacement)!!? I just a see a Config Mgr-not what I am looking for! ...
vb app performance
Hoosbruin -
10 Nov 2005 2:58 AM - 2 messages
I have a VB app connecting thru ODBC to a SQL7sp2 database. The server is N/T and he claims that performance throughout the day goes in the tank. The server has gig of memory and a dual processor. There are stored ...
SQL Server Agent Job Running for days
adam shea -
10 Nov 2005 12:30 AM - 2 messages
I have a SQL Server job that is running a xcopy using the cmdexec. All of the sudden the first step in the job that is running the first xcopy locks up the job in a running state for days. Job never fails or bombs out. I ...
Log Shipping
MS User -
9 Nov 2005 9:51 PM - 2 messages
SQL 2005 We have ~30 db's log shipped to a different server (LOGSHIP) . If any user connect to LOGSHIP \db1 then the hourly job keep failing for that db until the disconnect. That means if a connection open exits, log shipping process cannot apply the ...
suspected db? (SQL Server 2005)
Leila -
9 Nov 2005 9:37 PM - 5 messages
Hi, I created a database with an additional file group (FG2). Then created two tables: one on primary and the other on FG2. FG2 is located on my flash memory(USB) and when I disconnect the memory, the table is still queried and I can insert new records, while DBCC CHECKDB ...
Restart sql server Server.
MariaGuzman -
9 Nov 2005 9:29 PM - 2 messages
Hi, in the company we are evaluating if the server that has sql server installed must be restarted in an especify time. So I want to ask if somebody know it there is a guide or a best prices file that can help me to create te best escenario of restarting the ...
How to upgrade 2000 DB to 2005
Ben Amada -
9 Nov 2005 8:40 PM - 11 messages
Hello, I have a SQL 2000 database. If I want to upgrade it to 2005, do I just detach the DB from 2000, attach it to 2005 and change the compatibility level? That doesn't sound right. Does anyone know the recommended / ...
BACKUP/RESTORE compatibility between 2000/2005
Mark Rendle -
9 Nov 2005 8:31 PM - 5 messages
Hi If I take a backup of a database with compatibility level 80 from SQL Server 2005, will I be able to restore that backup into a SQL Server 2000 installation? Thanks Mark ...
Temp table vs Table variable.
Frank Rizzo -
9 Nov 2005 8:04 PM - 6 messages
According to an article by Mike Gunderloy ( [link] ), if I use a table variable instead of a temp table, SQL Server will still store the data in tempdb. So given this fact, what exactly is the advantage of ...
Manage Triggers grayed out
JLS -
9 Nov 2005 8:03 PM - 2 messages
What do I need to do to give someone access to Manage Triggers in EM? Is there a way to give them access to view triggers via EM, but disable their ability to create/drop? ...
When was a service pack was installed?
bpettus -
9 Nov 2005 7:41 PM - 4 messages
How does one determine when a service pack was installed? ...
create database statement
Homer -
9 Nov 2005 7:41 PM - 3 messages
Where does the SQL Server default the "file name" parameter when you create a database WITHOUT entering your own parameter for "file name". You can do a simple "create database somename" and it will create the database with the defaulted "file name" to be where SQL Server is installed ...
2005 - linked server query
Corey Bunch -
9 Nov 2005 6:42 PM - 4 messages
I had a database, stored procedure, and related job in 2000 that checked other servers (via linked server functionality) for failed jobs. Works fine in 2000. I migrated the database over to my local 2005 instance, and now the query does not work any longer. The below ...
Database Roles
Robert R via SQLMonster.com -
9 Nov 2005 6:07 PM - 4 messages
If I set up a user with a database role of dbo, does that automatically give him dbo rights on all objects in the database. For instance, can the user then execute a stored procedure in the database, or do you have to explicitly ...
Backups of tran log not working
tshad -
9 Nov 2005 5:44 PM - 19 messages
I have my maintenance plan set up to backup to disk each day, including the tran log. I am getting an error on the Tran log backup, however. It doesn't tell me why it failed, just that it failed. ...
|
|||||||||||||||||||||||