pretty new to stored procedures. I want to run two select statements, the first will get the userID, username and password from table_A The second will get the roles for the above user from the 'users_roles' table, but i need the UserID value to execute the second SELECT. I thought it would...more >>

Using SQL 2005, my principal database contains many filegroups but I'm only interested in creating a database snapshot of one of these filegroups. Specifying only one of the file names in the CREATE DATABASE databasex_snapshot ... AS SNAPSHOT OF databasex results in the error Msg 5127, ...more >>

I could have sworn I saw a spid with a negative number . Am I hallucinating or has anyone seen that before ? ...more >>

I decided to become MCDBA certified and bought a book (70-228) that will help me study for the first test. I pop in one of the CD's it came with and install the test questions. When I launch the program I get this: http://img154.imageshack.us/img154/7994/scripterror2zm.jpg Okay, I click ye...more >>

hi maybe a stupid question, but what do you think is the best data type if i need to save filesizes (in bytes)? i think varchar is not the fastest solution if i need to calculate some sum statistics about this sizes... Regards Marc ...more >>

I have a database that was 7GB. I wanted to shrink the database. In the Shrink Database screen it showed the free space at 69%. I specified Maximum free space after shrinking to be 25%. After shrinking it says there is 51% free. Does it not shrink it all the way down to 25% free? Should ...more >>

Hello, All! I've saw many information and commands about SQL-DMO, but I don't know what's is this and how to use it yet. Could you please explain me how to use and when is better to use this kind of command? Thanks Juliano Horta -- Message posted via http://www.sqlmonster.com...more >>

I have a maintenace plan set up to backup up the database to disk on the server, it is later picked up by Veritas and sent to tape. I would also like to send a copy of the .BAK file to another server. How can I add a step to the maintenance plan to do that? Thanks very much for any ideas....more >>

Hello, We have an SQL Server app written in ASP that suddenly has an error after 2 years of operation, and we're having trouble locating the problem. Here is the error message below. The reference in the Knowledgebase for this error doesn't seem to apply to us. There is plenty of space left...more >>

when I try to add a job I am unable to use the wizard the screen that holds the settings is corrupted I can no longer define how many backups have to stay in the folder (disk backup) I can set the number but the listbox after that stays empty so I can not set "hours" or "days" the job it...more >>

Is there any way that SQL Server can be forced to recognise files from 2 different databases? I am thinking that there is some setting in the Master database that can be changed, like an ID, or a GUID (which matches the file with their respective databases). If that value can be changed, I thi...more >>

Hello Group, is there any way to load only the Query Analyzer on a developer's PC. I have a developer that likes the look and feel of QA but I do not want to load the Enterprise Manager onto the users PC. Rich...more >>

in my table, I have several rows that are complete duplicates. Needless to say, I can't open the table and just delete 1 row. How do I delete the copies and not all? ...more >>

I'm planning to install SQL Server 2000 Enterprise Edition on Windows Server 2003 Standard Edition machine with 8Gb of memory. How do I force SQL server to use at least 6Gb out of 8Gb? Thank you in advance! Leon...more >>

We have a table that is showing a large amount of "reserved" space: Rows: 4095513 Reserved 11255328 KB Data: 1176296 KB Index_size: 531240 KB unused: 9547792 KB (found wiht sp_spaceused) We have only simple types in this table... no ntext or blobs or anything. Just int, small...more >>

Is it better to keep the tempdb data and log file on its own separate drive (Raid 1+0), or should I keep the tempdb data file on it's own drive and move the tempdb log file to the drive with all the other log files? Thanks ...more >>

I'm trying to reduce fragmentation of indexes on tables. When I run DBCC SHOWCONTIG on the table both befor and after dropping and recreating the indexes, including PK constraints, the results are the same? Any insight? I thought this would reorganize the data to be more efficient? What am...more >>

Hi, I'm looking to implement a paper-based service request form for all DBA related activities i.e., adding logins, users, tables etc... granting permissions, dropping objects, etc... Does anyone have a link to an online form that I can start with or have an in-house form (.doc) that I ca...more >>

I have created a DTS that exports the results of a query to an excel sheet and the delivers the xls to a group of users. The DTS will send the the email but not the attachment; however, if I execute the same statement using QA, the attachment works fine. I have the DTS authenticating to the loc...more >>

Can anybody shed some light on what I might run into when the FQDN is changed on SQL Server 2K? We are currently in the process of migrating several domains into a single .NET domain and there are several SQL Server 2K systems that will be changed. Researching this I have been seeing a lot of ...more >>

It would appear that Outlook 2003 (and 2002) does not work with SQL Mail, unless you are using an Exchange Server. The SQL Mail program and Outlook 2003 *BOTH* try to open the Personal Folder file (.pst file) and one of them fails. If I close the Outlook 2003 client, SQL Mail works fine, ex...more >>

Hello, I have SQL2005 64bit running on Win 2003 Itenium server. One of database is about 18 GB. Data file is 4 GB which is fine but the log file is 12 GB. I have run full backup nightly and run a Log backup at lunch time daily basis. ** Background ** This database is not being used mush ...more >>

Hi, I would like to setup a maintenance job to 'Rebuild Indexes' as my 'Optimization Job' keeps failing on "DBCC failed because the following set options have incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'. What command do I need to use to rebuild all the indexes on all the tables. ...more >>

Hello, We have two developer machines. One is running SS2K and the other is running SS2005. What we want to do is detach a SS2K database, copy it and then put it on the other machine and attached it to SS2005. When I attach the database, will it automatically be upgraded to a 2005 type data...more >>

I'm running profiler on databases that I thought were no longer being used. However I see a couple of lines in the profiler that have as application name DMO_1. My understanding of SQLDMO is very sketchy but is it a central connection used to access the dataabses rather than a specific nam...more >>

hello, we have a log in MSSQL\Data\MSSQL\Data\dm_Enterprise20050526161738_log1 that is over 50 Gig. Can someone tell me wht this log is? also we re-boot on the weekends, so if this log gets cleared after a reboot how could it grow so fast in 2 days? thanks for any help...more >>

need to write query... table1 fname points ----- ------ bart -10 homer 0 lisa 20 maggy 5 marge 13 table2 fname points ----- ------ bart 5 homer 7 lisa 8 marge -5 need to display report of names ordered by total score descending only if total is above 0 so re...more >>

Hello, I have SQL Server 2000 on my machine and just installed SQL Server 2005 but my registered server on my local machine still reads MyServer (SQL Server 8.0.760- MyServer\drake). Can I have two registrations on my local machine using Windows Authentication. One for the old version and on...more >>

Could anyone please offer advice on the following: I have a table in a SQL Server database, that I would like to put a trigger on. When an Insert is ran on the table, I would like to also run an insert on an Access database. The Access database is not on the same server, but is on a networke...more >>

Hi, I'm using SQL 2000 Standard and Windows 2000 Server Standard on one server machine. Ther real RAM is 3,25GB. I'm using TWO DB-instances. My question is, how much memory can I allocate (reserve) per instance? Due to limitations in 2000 Standard Server i cannot use parameters like /3GB,...more >>

Is there a way to remove Case Sensitivity from a SQL 2000 server? I can't imagine why anyone would set the server to this but one of my vendors did and I hate needing to know exactly where to put my caps.... TIA, Joe ...more >>

I have the AdventureWorks database in sql server 2005. The Table Person.Contact is empty. I have the .csv file for the data for this table. This .csv seems to be xml data. How can I get this particular .csv into this table? I basically would like to somehow populate this particular table. Than...more >>

I am trying to add a backup device to SQL that will use our NAS. When I enter the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a message that SQL Server can not verify the existenance of the backup file location. The path \\PROCOM-SERVER\BACKUP exist and I use it for other b...more >>

Hi, I get the following error when I try to connect to SQL 2005 Beta from VS 2005. "A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote h...more >>

HI, I am coming from an Oracle world. I would like to know if it is possible to use a specific partition name or number in SQL 2005 like we can Oracle: SELECT Mycolumns FROM MyPartitionedTable PARTITION(PartitionName) WHERE ... Let's say that MyPartitionedTable is partitionned by months, I...more >>

I’m trying to copy a very large amount of data about 10,000,000 records from one table to another using DTS. And while I’m doing the task although I can select data from the destination table using the sql query analyzer, I can’t execute the same select statement using ADO connection th...more >>

Can anyone please tell me where and how to configure SQL log files. I am a Network Admin person and don't know anything in SQL....more >>

Hi, can you tell me, how to change the server date and time using queries. Please advise me. rgds, Soura...more >>

My company have server with loads of test databases. last saturday its hard disk crashed all the partitions were lost . i tried to recover data from that disk and found my database folder. I took backup on another harddisk and tried to attache my databases but sql server says it not avalid datab...more >>

Hi, Does anybody knows how to get the value for "ImpersonateClient" property which is on IntegratedSecurity Object in SQL - DMO for SQL Server 2005 (Yukon). Documentation says that the functionality has been moved to "Server Connection" class of SMO but I couldnt find the property th...more >>

I have an sql server hosted externally. I want to view some of the stored procedures in a similar way to query analyser where you right click on the stored procedure select alter and you can see the stored procdure. I want to do this online. How do I get the stored procedure and what permissio...more >>

We are going Live with a large project at the end of the month. There is a primary server for the OLTP section and an additonal server for the users to run reports against a copy of the Live database. Fair enough. The machines are both very well specced for the amount of users the system wil...more >>

I have one UDD, which is used in some tables. Now i want to change its length. How can i do that ? ...more >>