Home All Groups Group Topic Search About



Score Collation Error: SQL Server 2005 DB
Joe K. - 21 Dec 2008 2:40 PM - 3 messages
I have a SQL Server 2005 database that I am trying to execute the t-sql statement listed below. I received collation error listed below from the query. Please help me modify the t-sql statement listed below to correct the error. ...
Score IN keywork with > 1 column?
DeanB - 20 Dec 2008 7:17 PM - 7 messages
Hi there, I'm playing with SQL server 2008 on my home project, after several years of using Oracle. Question is: is it possible to use IN with more than one column? select ADDRESS from PEOPLE where (FIRST_NAME, LAST_NAME) in ...
Score SQL 2K Defrag Utility Recomendation?
Bishop - 19 Dec 2008 4:46 PM - 6 messages
I manually run defrag utilities on my SQL 2K server using Query Analiser.  I wanted to find out any reasons I wouldn't want to purchase 3'rd party software to do this for me.  I also wanted any recomendations on which ones ...
Score SSMS Open Table Include Column Headers
NB - 19 Dec 2008 5:29 AM - 5 messages
Ok, I  know how to include headers when copying a result set from a query window.  But if I right-click on a table and click "Open Table", then see the results in the grid window and copy those results to Excel, how can I get ...
Score I HAVE A PROBLEM IN SQL
tariq313313 - 20 Dec 2008 4:11 PM - 3 messages
I have used SQL somewhat but I am not an expert. I can use select, update, where, like, query to some extent. I have a problem: One Table "Master_Table" contains a column 'Calling Number" which begins with the region code followed by telephone number e.g. in ...
Score Backup and restore database to another server
Starfish - 19 Dec 2008 4:31 AM - 5 messages
Hi, I have two SQL 2000 servers. Both servers have a database named "Production." I need to backup this database on Server1 and then restore it on Server2 with a different database name. In other words, I want to restore ...
Score Cursor Logic
Janet - 19 Dec 2008 7:32 PM - 9 messages
I am working on writing my first SQL cursor.  I've borrowed code from a few existing cursors that are similar to what I need and I think I am close but not quite there.  I've included it below. ...
Score Help on Sql Server 2005 job steps lost
Roberto Rasto - 19 Dec 2008 10:18 PM - 3 messages
I had to reinstall my sql server 2005. After that I copied the old master database to the new installation. Everything is working, but I lost the job steps. I have the old jobs, ma inside each one I have no steps. ...
Score Still Restoring...
steve@mcmillaninc.com - 19 Dec 2008 1:02 PM - 9 messages
I had problems trying to restore a database. I finally got the restore to run with "NORECOVERY" That was two days ago and, the server management studio still shows the database with a green up arrow and the words (restoring...) after the ...
Score LogFile size - general information
Walter Sporn - 19 Dec 2008 7:55 AM - 3 messages
Hello, I am no expert in SQL server but for my job I have to manage an application that works with MS SQL Server and so I tried to find answers for some of my basic problems but I did not really get them. So I hope you can help me! ...
Score bak file = 5gb, attempted restore claims its 100Gb
Scott - 17 Dec 2008 5:55 PM - 5 messages
this is a new one on me: SQL server 1 holds DB1 its a 100GB file approx I back it up Restore it on SQL server 1 as DB2 Truncate large tables DB2 now = 5Gb approx BACKUP. My .bak file = 5gb ish. ...
Score High CPU Use
Chuck P - 12 Dec 2008 3:29 PM - 10 messages
I have a 4 cpu box with sql05 on it. Task manager shows two sqlserver.exe running each at 25% cpu and 5 gig memory.  This is at 6 am with NOTHING going on. If I run --ActiveSessions.sql ...
Score Backup multi database
checcouno - 18 Dec 2008 7:31 AM - 8 messages
I have two db in my SQL Server 2005 engine. DB1 and DB2. I have a transaction that work over the two DB. If i start backup of DB1 and DB2 during the transaction, is possible have this scenario: on DB1 the transaction is not committed and when start backup ...
Score MS Access, ODBC, SQL 2005, delays before data appears
Gijs - 3 Dec 2008 8:30 AM - 6 messages
Hi all, We are using MS Access as a front end, SQL Server 2005 as the backend. Tables are linked using ODBC (they are attached using code). the cursorlocation is adUseClient. We do not seem to have any problems but occaisionally we seem to 'miss' ...
Score Big deletion is filling transaction log
Carlos Felipe França da Fonseca - 18 Dec 2008 4:41 PM - 4 messages
I need to delete thousands of rows in a table. What's the best way to do it without filling the transaction log file? Thanks, Felipe ...
Score SQL Server 2005 Performance
sjg - 17 Dec 2008 6:12 PM - 3 messages
We're seeing a strange thing occur with a process that only reads the database via views and stored procs.  After a certain point in the process a significant slow down occurs.  We're not seeing anything sginificant in ...
Score SQL SErver 64 bit use of memory
Joe - 3 Dec 2008 2:54 PM - 5 messages
Hello, Server 2003 EE sp 2 64 bit 8 gb of RAM SQL Server STD edition sp 2 64 bit  6144 max server memory.  AWE is set.  Lock pages in memory is set.  SQL has not been stopped/started  ...
Score SQL Server 2008 - remote connection problems
Iain - 12 Dec 2008 1:55 PM - 5 messages
Hi all - hope you can help I have a SQL Server 2008 instance running on a Server 2008 box and can connect perfectly fine with machines on the network but outside the network I cannot connect at all.  I have done the following and still cannot connect ...
Score Partial restore without restoring PRIMARY FG
subs - 16 Dec 2008 2:03 PM - 4 messages
I previously posted a question on how to restore a single filegroup to a database, leaving the others intact. [link] Put simply, Live Db with two filegroups, PRIMARY and AUDITLOGS.  When ...
Score testing 2000 to 2005 update
Keith G Hicks - 16 Dec 2008 5:46 PM - 10 messages
I think I remember hearing about something that could test a SQL 2000 db after it's been attached to SQL 2005 server to be sure there are no funny things in the db that will cause problems in 2005 (especially coding issues ...
Score bcp delimiter
stavros - 17 Dec 2008 12:19 AM - 5 messages
Hi, Is there a way to tell bcp to insert a single space character as a field terminator in an output?  BOL seems to indicate it's possible, saying that you can use "any printable character" as the delimiter, ...
Score Testing Environment + TestData + QA Setup
MS Techie - 9 Dec 2008 2:38 PM - 4 messages
Database is SQL 2005 and Front End is in C# ---------------------------------------------------- I'm looking for a good strategy to save my data that I use for testing. I made a set of good test data, and backed it up.  I write my programs, ...
Score Query is very slow then fast
ivo - 16 Dec 2008 7:35 PM - 5 messages
Hi, I have a question. I have a rather large table in my database and the first time I run this query select count(id) as total from table It takes over 10 minutes to return a result. Sure, I know now that ...
Score sql server hung
Ed - 12 Dec 2008 3:43 PM - 6 messages
hi all, Recently, our one sql server 2000 windows 2003 always hung and then we have to reboot the server.  checked the sql log and the only one shown as  "The log file for database 'tempdb' is full. Back up the transaction log for the ...
Score SQL 2008: How to recursive Procedure for parentNavigation?
Andreas Klemt - 13 Dec 2008 11:04 AM - 3 messages
Hello, how can I do a recursive Procedure in SQL 2008 to get all parentNavigation Nodes for this example? navigaionID   parentNavigationID   Level ------------------------------------------ 1                  0                                0 ...
Score Transactional data fun...
GrandNagel - 17 Dec 2008 7:05 AM - 2 messages
I have a series of records that relate to various people in another table.  These records are a compilation of an individuals status over time.  Whats the sql to obtain the most recent status given the following criteria.. ...
Score Problems with NOEXPAND
Emiel - 14 Dec 2008 2:41 PM - 5 messages
The following SQL statements produce an unexpected result. I would expect that the two select statements would result one row, but the first one doesn't. Is this a bug of a feature? I'm running Microsoft SQL Server 2005 - 9.00.3068.00 (Intel X86) Feb 26 ...
Score Transaction Log Backups
Anonymous - 15 Dec 2008 5:20 PM - 5 messages
SQL Server 2000 Will a transaction log backup occur via a maintenance plan if there are no changes to the database? There is a maintenance plan on the server that does a complete backup and transaction log backups on several databases.  However, I noticed that only ...
Score Downloading Query Analyzer?
Maury Markowitz - 10 Dec 2008 4:56 PM - 6 messages
We have a SQL Server 2000 install and many clients that run ad-hoc queries against it. Is there an installer package for Query Analyzer? I can't seem to find one, and using the master install disks is a ...
Score How to look for values in a table
stacko111 - 10 Dec 2008 3:07 PM - 5 messages
Hi - pretty basic question but I want to look up for a certain value in a table. I have the need to modify the data in a table from time to time, the table is very large and doesn't seem to be in any specific order. Currently I have ...
Score dbcc shrinkfile
tulip - 11 Dec 2008 9:59 PM - 7 messages
when you specify dbcc shrinkfile notruncate or dbcc shrinkfile truncateonly, how do you know that the transaction log file would shrink to what size? we had a rebuild index job run every weekend, after that, the t-log become 10G, ...
Score Command to quit executing query through script
deostroll - 13 Dec 2008 4:46 AM - 3 messages
I have a huge script with a lot of go statements. In one of those batches how can I stop further processing of this file if for e.g. some condition pertaining to my processing logic is met? Tried quit, exit nothing works. Tried using return but processing ...
Score Pending Reboot Requirement
circulent - 24 Oct 2008 1:04 AM - 5 messages
We are trying to uninstall a database on a SQL Server 2005 box, and I keep getting a 'Pending Reboot Requiment' message which prevents me from going any further. Some posts suggested I clean out the PendingFileRenameOperations values key from HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager and ...
Score Query with dinamic columns
dandi - 7 Dec 2008 10:11 PM - 9 messages
I've a table with the details (rows) of each invoice CREATE TABLE [dbo].[DocumentiPassiviDettaglio](      [IDDocumentoPassivoDettaglio] [int] IDENTITY(1,1) NOT NULL,      [IDDocumentoPassivo] [int] NULL,      [IDPianoDeiConti] [int] NULL, ...
Score listing sql server and instances
Jean Gaudreau - 11 Dec 2008 4:57 PM - 5 messages
I'm trying to detect all the servers and instance in the SQL Management Studio 2005. We have 2 separate networks. On one network, it seems to work well.. I can see all the servers and instances. On the other network, I'm only able to see one server (WSUS) and his ...
Score text to number <--SQL rookie here Options
Dan - 12 Dec 2008 12:26 AM - 10 messages
Hello - I have the following query which is need of converting the Height, Width, Depth data into a number.  It is currently being stored as text with extra spaces at the end in the database it comes from.  Any ...
Score SQL 2000 and 2005 On Save Box
Jeffery Rehm - 11 Dec 2008 1:00 PM - 6 messages
Are there any issues with 2000 and 2005 SQL on the same server?  Have a machine with both and the perception is that the server became unstable with the 2005 install, although I'm not convinced that if it is unstable the 2005 ...
Score SQL2005 spaces in T-SQL
david.brunning - 10 Dec 2008 2:34 PM - 5 messages
if I run the following statement in SQL Server Mgmt Studio:     select len('        ') I get 0 returned.  Is this expected? ...
Score SQL 2005: "Function argument count error." error
Conan Kelly - 11 Dec 2008 7:22 PM - 4 messages
Hello all, I'm trying to use the CHARINDEX() function in a view. Help/BOL tells me that it has an optional 3rd argument for the starting position: CHARINDEX ( expression1 ,expression2 [ , start_location ] ) ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/78c10341-8373-4b30-b404-3db20e1a3ac4.htm ...
Score Combining 2 queries
Janet - 9 Dec 2008 8:46 PM - 7 messages
I've got the 2 queries below connected with a UNION statement.  I need to combine them into 1 query because I am getting duplicate rows in my result set for students selected by the 2 separate queries.  I am not ...
Score Access 2000 or 2003 project - can it connect to sql server 2008?
jd_nospam - 10 Dec 2008 6:45 PM - 3 messages
Hi, I have a couple of access projects that use SQL server as their backend, several of which are in Access 2000 and 2003.  Since Access 2007 causes Access 2000/2003 projects to not open correctly if they are on the same machine I'm currently creating new projects in 2003 ...
Score Active/Active/Active Cluster question
tolcis - 11 Dec 2008 1:51 PM - 4 messages
Hi! This is the first time I have to setup Active/Active/Active Cluster and I am not sure on how many instances I have to install on each node. Because of the hardware constraints I have to build one node cluster ...
Score performance question - high cpu usage
SarahG - 10 Dec 2008 8:53 PM - 4 messages
Hi, I have sql 2000 server, standard edition, 4GB, 8 processors, I only one tempdb data file and 1 log. I found lately, one of my sp running, it caused very high cpu usage, because of the sql standard edition, is there anything ...
Score Collation Issue
faygate - 11 Dec 2008 10:52 AM - 5 messages
We are installing 64 bit SQL Server 2005 on a Windows 2008 64 bit Server. However, no matter what we do it is setting the server collation to SQL_Latin1_General_CP1_CI_AS even though since the locale of the server is set to United Kingdom it should be setting it to Latin1_General_CI_AS. Indeed ...
Score An error occurred during the execution of xp_cmdshell. A call to 'CreateProcessAsUser' failed with e
George Wen - 10 Dec 2008 5:56 AM - 5 messages
Hi All, I was trying to assign non-sysadmin users permission to run cmdshell without luck. The steps I ran thru: 1. check sql server 2005 version --select @@version --shows SP2 3042 2, run cmdshell command as sysadmin user and it works ...
Score Partition Table Split Range Performance
Lijun Zhang - 9 Dec 2008 9:56 PM - 4 messages
I have a table with over 300 millions records. The total space used by this table is around 120 GB. The table is used to records some activities. One column is the activity date. We only keep 2 years of history data in this ...
Score the alert couldn't send an email
Iter - 10 Dec 2008 5:02 AM - 5 messages
Hi Guys, I have a question regarding alert in sql server 2005. I created an alert which sends an email when the data file exceed the size. The alert didn't send an email out when the data file exceed the size. In the biginning I got ...
Score Intermittent and undesired SQL execution performance behavior
Martin Gasevski - 9 Dec 2008 7:29 PM - 3 messages
All, Please help!  Have a trully bizarre (at least to me) performance case that cannot put a finger on and need prompt resolution advice as its been troubling me for weeks on. The sproc is attached.   At first I suspected its the nested views, so ...
Score Migrating SQL2000 Databases to SQL2005
Julie - 9 Dec 2008 2:36 PM - 4 messages
Good Morning, I have a generic question in regards to migrating databases from a SQL2000 Server to a SQL2005 Server.  I am basically looking for suggestions on the best way to do this. The current SQL2000 Server is running Windows Server ...
Score where to find the errors generated by stored procedures
SarahG - 9 Dec 2008 4:48 PM - 4 messages
Hi, I have a silly question. I'm using sql2000 and there are a lot of stored procedures. I would like to trace the error which one of the procedures throws, where can I find it? Would it appear in sql log or event log? ...
Score ORDER BY @OrderBy problem
ThatsIT.net.au - 9 Dec 2008 4:40 PM - 4 messages
I get this error from the following code as last modified is a date., I can cast it as varchar but then it sorts as text not date. any ideas Conversion failed when converting datetime from character string CASE @Direction ...
Score Restoring single filegroup
subs - 8 Dec 2008 4:45 PM - 6 messages
I have a live database server which I want to mirror on a test server every month. I have around 30 databases on each server, all with the same structure and filegroups.  Each database has two filegroups, PRIMARY and AUDITLOGS. ...
Score Error logs enormous. Can I delete or save elsewhere?
Roger Withnell - 3 Dec 2008 11:10 AM - 10 messages
I am referring to the 6 error logs in: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG. The total size is over 6gb and growing because of invalid logins from hackers.  This is filling up my small C drive. ...
Score Using Alias with Failover
deconinckg - 5 Dec 2008 2:49 PM - 3 messages
In the following article Microsoft refers we can use a T-SQL script on a job after failover, to change the alias. [link] I didn't find out how to run a job after failover yet, but I'm more ...
Score Cursor Help
anaylor01 - 4 Dec 2008 12:52 AM - 6 messages
I have a one column table. The data in that column has 1142 characters. It is fixed delimited data. To make it more dynamic for parsing the data I have created a table that has the fieldname, fieldlength and field size. I want to ...
Score Disaster Recovery Options
Bryan - 4 Dec 2008 4:50 PM - 5 messages
I am looking for general ideas to explore based on the following requirement: We want to be able to backup a database or database files (off site or to tape) that is currently the recipient of Log Shipping without disrupting the ...
Score Backup and Restore Problem
Tony Starr - 6 Dec 2008 4:36 AM - 5 messages
I need some help. Today, every time I try and resore a database I get the following message. System.Data.SqlClient.SqlError: The tail of the log for the database "XelonReleases" has not been backed up. Use BACKUP LOG WITH NORECOVERY to ...
Score SQL GROUP BY CLAUSE
keyur joshi - 1 Dec 2008 9:26 AM - 4 messages
hi i have made a view and its out put will be the following InvDt           ItmNm           Qty              Mrp ...
Score What can cause SQL 2000 to stop responding for a while
JN - 5 Dec 2008 3:05 AM - 4 messages
I have a SQL Server 2000 that has a couple of databases on it.  One is couple of gig with about 30 tables and another is about 60 gig with about a dozen tables but almost all of it is in 3 tables. ...
Score replicate image of DB at a remote site
fiaola - 5 Dec 2008 1:43 AM - 6 messages
Hello, I'm searching for information on replicating DB for disater recovery.  I read online that some people do not recommed the SQL Server replication procedure.  Can you recommend a software or a good way to replicate DB to ...
Score JOIN based on date
morphius - 5 Dec 2008 5:02 PM - 8 messages
How do you get rid of the time so that the JOIN statement below will work. Table1.date 1/1/2008 22:00:00 Table2.date 1/1/2008 00:00:00 SQL statement: SELECT tb1.name, tb2.salary, tb1.date ...
Score SQL Server 2005 Script Out User Permission Prod-> Dev
Tim Peterson - 4 Dec 2008 10:57 PM - 4 messages
I have a SQL Server 2005 production database that has approximately 75 users. I would like to restore the SQL Server 2005 production database into my development database. What the best way to script out the development users permissions to be ...
Score Server Disk Space
John Bigbooty - 2 Dec 2008 8:00 PM - 9 messages
Is there a reliable way to get the amount of disk space available on a computer running SQL Server? xp_fixeddrives was a start but since it is undocumented and doesn't appear to work with a remote 2005 server, it isn't a complete ...
Score DBCC Checkdb's torn page / checksum validation
abair34 - 3 Dec 2008 8:14 PM - 3 messages
If you have a database who's page verify option is set to none does performing a DBCC CHECKDB actually do any page verification?  My intuition says that it cannot because the pages that were stored would have been stored ...
Score SQL Server 2005 Maintenance Plan Error
NigelA - 28 Nov 2007 5:16 PM - 13 messages
I have tried to run a maintenance plan which is just a Check Database Integrity task set to: Target server connection, All user databases, Include Indexes. It claims to run OK but then viewing the history shows it has failed with the error "Alter failed for Server 'XYZDB02'" ...
Score Trigger and Misc.
Rodger Dultrie (not the actor) - 28 Nov 2008 4:43 PM - 17 messages
We have a few issues that we hope to get some information on as follows. We are not sql gurus and are learning on the fly (not the best, but we have to deal with this on a day by day basis while we interview SQL dbs). ...
Score Cumulative package 2 for SQL 2008
dwu - 2 Dec 2008 9:31 PM - 4 messages
Did anyone download Cumulative package 2 for SQL 2008? How many files you see after extracting the compressed file. Currently i only see two files--sqlncli.msi and hotfix.txt. It looks like MS missing the hotfix.exe in the package. Could someone confirm what i see? ...
Score Problem in sysdatabases
Simon - 4 Dec 2008 3:45 PM - 4 messages
I get the following error message when I try and loop through all databases to perform a query using sp_MSforeachdb. 'Could not locate entry in sysdatabases for database 'OrtusSearch'. No entry found with that name. Make sure that the name is entered correctly.' ...
Score Is it possible to associate sql login with network address?
George Wen - 4 Dec 2008 11:31 PM - 4 messages
I was looking into a way to associate sql login with network address, e.g. user 'sa' will only be able to login from localhost or a particular ip range, does anyone know whether it is possible? I know that mysql does this pretty well. ...
Score Can a trigger be inadvertantly disabled?
JoelB - 3 Dec 2008 9:20 PM - 10 messages
A customer reported some odd behavior, and it turned out to be because a trigger was disabled.  Access to the SQL Server is quite limited, and it seems very unlikely that anyone intentionally disabled this trigger. Is there any way---like if the system has a problem with the trigger or ...
Score FT Index - Avoid Noise Words
dbenoit - 4 Dec 2008 5:42 PM - 3 messages
We have a Full Text index which works great but we have some data which doesn't play well with the Noise Words and I am wondering if there is a way that I can avoid the use of the Noise Words for a specific query without ...
Score Re-attaching database
topokin - 1 Dec 2008 7:57 PM - 13 messages
A database was generating some problems because of disk place, so I detached it and move the files to another location. However when trying to re-attached the database, I receive an error message: Error 3624 : 1450 Transactions rolled forward in Database <xxx> ...
Score SQL 2k5-32bit >SQL 2k5-64bit
John Holt - 1 Dec 2008 9:49 PM - 5 messages
Many times I have installed SQL to a new server, shutdown the service and copied over the entire MSSQL\Data folder, master,msdb and all, start the server and bam!, just sp_dropserver and sp_addserver and change the servername in the jobs table and everything is on the new server without a ...
Score how to store decimals in tables
fiaola - 3 Dec 2008 4:20 AM - 8 messages
I have a table with a field called weight, which i have it as a decimal(18,2) data type.  When i tried to store a value like 9.97, the actual data stored in the table is rounded off to 10.  How do i fix this? ...
Score Script to delete records from a table older than N number of days.
Fuel451 - 3 Dec 2008 4:51 AM - 9 messages
I have a table within a SQL 2005 database that fills up after about three months and I'd like to schedule a daily job to delete rows or records older than 60 or 90 days. Could someone provide the syntax for a DELETE script? ...
Score Security Question
Eric - 3 Dec 2008 12:29 AM - 8 messages
Hi All, If I want to enable a user to extract up to 200 rows per a request, how that can be done? Is it possible to control? Thanks, Eric ...
Score in full recovery mode but log keeps self-truncating
JRStern - 2 Dec 2008 10:21 PM - 10 messages
We have a dev database we keep in simple recovery mode.  We restored a fresh copy of the database from production, and it was set down to simple mode.  The log file was only 500kb.  We set it up to full recovery mode.  We're ...
Score The time stamp counter of CPU on scheduler id X is not synchronized with other CPUs
Paul Cahill - 3 Dec 2008 12:34 PM - 3 messages
We are shortly going to go live with our new (and 1st) 64 bit server. I have just noticed the above errors in the Application Log. The system is an HP DL580G5 with 4 x 6 core Xeon x7460 Cpus. It is running ...
Score Maintenence Cleanup Task does not delete backup files
mat - 2 Dec 2008 7:42 PM - 3 messages
I'm testing a new Mainentence Cleanup Task that runs inside the same subprocess as the backup task. I have it set up to delete .bak files in the backup dir that are older than 1 hour (for testing). When I run the ...
Score Consolidate datafiles to one drive
Abba - 2 Dec 2008 8:04 AM - 6 messages
Hello, My database has 10 datafiles spread across 10 drives. We designed it a year back anticipating heavy traffic but it didn't turn out that way. Now, I need to give all those extra SAN space back and so need to put 9 datafiles to a ...
Score Max server memory being ignored
Jason - 2 Dec 2008 2:16 PM - 10 messages
Our SQL Server 2005 database appears to be ignoring the max server memory setting. The server has 16 GB of memory, and we set the max server memory at 14 GB. Ops Manager keeps warning of low memory and task manager shows all memory being used. This is a deticated 64-bit ...
Score Best practices for error handling in SQL Server procs
NeoRev - 20 Nov 2008 6:15 PM - 33 messages
One of our clients has just developed a set of coding standards for their ..NET and SQL Server application development. For the SQL Server standards, they say the following regarding error handling: -----------start of quote--------------- Error Handling - Should be used in every stored procedure, with an Error Handling section ...
Score Adding memory has degraded performance
Mike Wazowski - 29 Nov 2008 5:16 PM - 5 messages
Hello Experts We have an active/passive failover cluster running on some decent IBM X Series servers, quad x64 Xeons with 16 Gb of RAM. We upgraded each server to 64Gb.  As the server started eating into the new ...
Score can u help me in populating random data more than 32767 rows
sunny raju - 26 Nov 2008 10:38 AM - 4 messages
hi Razvan Socol the give none working fine, but this query is populating up to 32767 rows only. After that its giving error. can u please provide the information regarding that. ...
Score SQL Server to Microsoft Exchange
musosdev - 30 Oct 2008 11:16 AM - 6 messages
Hi I'm not sure if this is the right group, but I'm looking for information on how to get our Contacts database (which is in SQLServer) into a Public Address book on Microsoft Exchange. I trawled the net and found the following article on SQLServerCentral... ...
Score Database Mirroring not synching till I open Mirroring Monitor
dba - 25 Nov 2008 7:54 PM - 6 messages
Hello All,     I'm rather new to mirroring, I had to setup the princible and the mirror using certificates per the example in BOL. I am using asychronous mode. Everything looks good till I launch the Database ...
Score Alter Index On Database Rebuild (SQL Server 2005)
Joe K. - 30 Nov 2008 6:17 PM - 6 messages
I have a SQL Server 2005 database that I am trying to rebuild the indexes. I used the ALTER INDEX ON TABLE_NAME REBUILD on each table. After completing this task I ran the DBCC SHOWCONTIG on each table. I noticed the logical scan fragmentation is set between 25 - 80. ...
Score Migrating SQL 2000 to SQL 2005, any risk I change db collation too?
serge - 29 Nov 2008 7:38 PM - 8 messages
Hello, I am restoring SQL 2000 databases to a SQL 2005 SP2 where the SQL server's collation is Latin1_General_CI_AS. The SQL 2000 database backups that I am restoring have their collation as SQL_Latin1_General_CP1_CI_AS. Other than running SQL 2005 Upgrade Advisor, I scripted out the ...
Score SQL Server 2005 SSMS List Role Permission
Joe K. - 27 Nov 2008 3:50 PM - 3 messages
I created a role within a SQL Server 2005 database that I assigned permission to tables and stored procedures.  How can I display the permissions associated with this role? Please help me with this issue. ...
Score SQL Server 2005 Cannot refer column Schema Across Database
Joe K. - 29 Nov 2008 6:37 PM - 2 messages
I have an AdventureWorks database that I created a snapShot (AdventureWorksSP).  I deleted several ContactIDs from the Person.Contact table.  I drop the Person.Contact table from the AdvenureWorks database.  I would like to use a SELECT * INTO Person.Contact From AdventureWorksSP to ...

Developed using NextGeneration, the .NET Code Generator Try AdSense Reporter, the charting tool for AdSense publishers