Home All Groups Group Topic Search About

Score Possible problem with differential backups
JoshBond - 8 Sep 2010 5:30 PM - 8 messages
Hi all, I have a 170GB OLTP database that only processes INSERTs and SELECTs, no UPDATEs or DELETEs. I add about 1.8GB of data every day, as verified with my transaction log backups taken every 15 minutes. A full database backup is created every Friday at 10PM and then ...
Score SQL IN
kpg - 10 Sep 2010 8:03 PM - 4 messages
Hi all, Using ASP.NET, SQL SVR Express 2008 I want to use IN to select records that have one of a list of values like this: SELECT * FROM MyTable WHERE MyField IN ("Value1","Value2","Value3") MyField is a nvarchar(MAX) ...
Score Locking in merge statement
schaf - 10 Sep 2010 11:52 AM - 3 messages
Hi All, I have a table which contains some status information. Table1 (device varchar(200) primary key, NumberOfUsage int) Now I have a store procedure in which I would like to insert new devices, if they do not exists. Otherwise I just want to update the ...
Score Maintenance Plan - General beginner questions
Noncentz - 9 Sep 2010 3:41 PM - 5 messages
Morning, I am creating my first maintenance job today and I have some general questions about the order of steps regarding the db and t-logs. I am looking to create 3 jobs that run nightly on a production database for my company. ...
Score Disk Setup for SQL Server
Matthew - 7 Sep 2010 1:32 PM - 3 messages
I'm looking to install a SQL Server into my virtual infrastructure.  My hardware is setup like this... virtual host with 10Gb ethernet, SAN with 12 drives setup in a raid 5 (I believe 64k clusters). I've been looking over the SQL Server best practices and generally they ...
Score Linked server and sensitive to register name
Dmitry Kovalenko - 6 Sep 2010 10:47 AM - 2 messages
I try to work with table with "sensitive to register" name through Linked Server (MSSQL 2005/2008) and get the problem with UPDATE statement. Reason: MSSQL generates UPDATE statement with "un-quoted" table name. With SELECT/INSERT/UPDATE - no any problems. ...
Score Variuous ways of deleting Job history and deleting the job history log files from the folder
Gopinath Rajee - 5 Sep 2010 2:32 PM - 4 messages
All, when we create a job via the maintenance plan, we have the option of including "Clean up History" and "Maintenance Cleanup Task". Via the "Clean up History" task, we normally specify how far back we want to maintain the ...
Score Database State OFFLINE
rgn - 3 Sep 2010 3:16 PM - 5 messages
All, I want to understand the OFFLINE database state better. Suppose, if I want to move a database to another drive after the executing "ALTER DATABASE A SET OFFLINE" and copying the files to another location, how would I set the ...
Score non-brand name memory and cluster failure
Dan Holmes - 3 Sep 2010 3:06 PM - 3 messages
I have a Sql Cluster that failed with the following message in the event log. 'SQL Server' in Resource Group 'Disk Group 1' failed. The customer is suggesting this might be related to additional memory installed that is not of the same brand as the ...
Score Losing SQL connection
DavidC - 1 Sep 2010 8:24 PM - 4 messages
We have SQL 2008 server on our network and I am periodically losing connection to SQL Server on my Win 7 PC.  I will be working in and out of SSMS all day and then all of a sudden I get "A network-related or ...
Score RE-Raiserror in error handler procedure
schaf - 3 Sep 2010 7:09 AM - 5 messages
Hi NG, I have a store procedure which is my error handler. In each catch- block of a try/catch a call this function for error analization. Now in some cases I would like to re-raise the same error from this ...
Score Find UnUsed Stored procedure
Gal - 2 Sep 2010 7:39 AM - 3 messages
I have lots of unused SP in my DB and i'd like to delete them. I need to find them. How can I know that a Stored procedure is not used. (with the tables i look at the DMV). ...
Score SQLState=S1000, NativeError=0
ironryan77 - 1 Sep 2010 4:03 PM - 5 messages
I am trying to use the BCP command to execute the following statement, but I keep getting the following error: Starting copy... SQLState = S1000, NativeError = 0 Error = [Microsoft][SQL Server Native Client 10.0]Unexpected EOF encountered in BCP data-file ...
Score Sql Server Version # from dfb file
kpg - 1 Sep 2010 9:07 PM - 3 messages
Hi all, Q1: Is there a way to tell what version number a dbf file is? Q2: Where can I find a list of version #'s, ex, 621 = SQL 2005 Background: Using VS2005 and VS2010 with SQL Server 2005 Express.  Somehow the DB on ...
Score dealing with invalid dates
soni2926 - 1 Sep 2010 6:16 PM - 4 messages
Hi, Is there a way to deal with invalid dates during a select? Currently I'm getting dates in a column in this format: 20100726  (yyyy/mm/dd) I need to display it as 07/26/2010, so i was using this: ...
Score Problems installing "Microsoft SQL Server Management Studio Express" on Win7 64Bit,...
Kerem Gümrükcü - 30 Aug 2010 2:45 PM - 4 messages
Hi, first i must apologize for crossposting but i hope someone has a answer for this: I try to install this (the 64 bit variant on my Windows 7 64 bit): [link] ...
Score Linked Servers
LisaM - 26 Aug 2010 3:57 PM - 3 messages
I would like to create two linked servers to the same data source.  The first linked server has fairly open access to the database.  The second linked server will have limited access to the database (readonly on one view).  The ...
Score how to prevent simultaneous access to a table?
Luc - 14 Aug 2010 1:48 PM - 25 messages
Hi, Students can subscribe for any project via a webform. Table 'project ' contains all the proposed project and table 'student' contain the name of the student and the project-id. Now, suppose there is a limit of 4 students for project 'A' and there are ...
Score SQLServer Error: 802, 701, 733
Bernd Maierhofer - 3 Aug 2010 6:54 AM - 19 messages
SQL Server 2008 on Win2008 R2 x64 Server, 8 GB RAM - running virtualized on VMWare ES-Server Every sunday some maintainance jobs are scheduled to run. Rebuilding indices and statistics fail with messages: [298] SQLServer Error: 701, There is insufficient system memory in resource ...
Score Create trigger
Kareem via SQLMonster.com - 25 Aug 2010 6:53 AM - 6 messages
Hii, Can any one please let me know the process that how can we create trigger so that it grab the job failure logs when the job fails and that error log details will sends to mail via SMTP. Please provide some URL's for this task is much helpfull for me. ...
Score convert(binary(4), @Number) not giving expected result
Brian - 26 Aug 2010 6:56 AM - 6 messages
Hi I thought the following code would give me a result of 1101 bit instead it gave me 0x00000000D. declare @Number int set @Number = 13 select convert(binary(4), @Number) select cast(@Number as binary(4)) What I wan to do is convert a integer or number to binary. (2s Compliment) ...
Score Mutually Exclusive Set Comparisons
Flam_B - 22 Aug 2010 5:51 AM - 14 messages
Hi there, I've been toying around with a problem for months and have had little success in answering it; mostly because my limited ability to describe the problem. I've created a series of queries to set up sample data.  I also took the ...
Score the incoming tabular data stream remote procedure call is incorrec
M. Wilson - 25 Aug 2010 8:54 PM - 4 messages
Hello, I am using SQL Server 2008 Express with sql native client 10.0 as a backend to an Access frontend.  When I try to updated one of the linked tables in Access, I receive a server side error message stating "The incoming tabular data stream (TDS) remote ...
Score Inherited column collation
JimLad - 24 Aug 2010 2:02 PM - 9 messages
Hi, Just to clarify, my understanding is that all column collations are hardcoded and there is no inheritance structure. Is this correct, or does SQL know internally whether collation is inherited from the database default or whether it was explicitly specified for the ...
Score Query execution plan problem
Bozena - 24 Aug 2010 8:23 PM - 8 messages
Hi, I have encountered a problem with a query execution plan on MS SQL Server 2008. It is a simple query on a single table. The table has a primary key RNUM (number(10)) with a clustered index. The query is executed via ODBC ...
Score How to use datepart in below scenario
george_faz via SQLMonster.com - 25 Aug 2010 2:53 PM - 4 messages
Hi Guys, I have the following dates: 8/23/2010 6:30:00 AM 8/24/2010 6:29:00 AM 8/25/2010 7:00:00 AM 8/26/2010 5:00:00 AM 8/23/2010 6:30:00 AM/ is Monday but i want to treat also 8/24/2010 6:29:00 AM ...
Score Create Clustered Index on View Problem
RobJones - 24 Aug 2010 11:49 AM - 4 messages
Hi, I've got a annoying problem that our DBA can't help with. We are dropping and recreating indexes on tables/views in our overnight batch to allow quick insert of data. This works normally well, however on a couple of occasions ...
Score create View showing a conditional field
LuisM - 22 Aug 2010 12:39 AM - 5 messages
How can I create in a view, a calculated field (name) that depends from other field (value) as follows: if not isnull(value) then (name) ="Discount" else (name) = null thanks for your suggestions LAM ...
Score Show int field as fixed lenght field
LAM - 21 Aug 2010 12:42 AM - 5 messages
Using a view, I need to fullfill with zeros (0) at the left of whatever number found in a integer field, converting it to a fix lenght of 6 characters. Also, I would like to know how to show a datetime field under ...
Score Appears to be a Service Broker Transmission Queue Send Threshold
Charles - 15 Aug 2010 11:36 AM - 8 messages
Hi all I'm using SB to pass messages from one server to another. Data come into the first server as a regular stream of discreet messages, and I have all the infrastructure set up to queue the data and forward them to the remote ...
Score error while using case statement
cauverypoonacha - 19 Aug 2010 7:49 AM - 2 messages
Hi,     I have to modify an existing query as below existing logic: and table.location in (select city from tablename1 where col=col) New logic: Now if the column table.loction' is null then I have to use the below logic ...
Score Locking in SQL 2005
RG - 18 Aug 2010 9:01 PM - 6 messages
I have an insert table trigger which amongst other things, massages inserted column value.  Within this trigger, I am stuck with select and then insert statement.  To prevent duplicate looking at the same data, I put the select ...
Score Delete all fields in database...
RAB - 19 Aug 2010 12:35 AM - 5 messages
I have a sql database on Godaddy.com.  I was wondering if there is a way of deleting all the fields in the database using a query?  I want copy and deploy a duplicate website with an empty database. ...
Score skip db offline run job backup
Angar - 16 Aug 2010 9:20 AM - 4 messages
good day I make a backup via query set to a job, my problem is that when the DB is offline I blocks the execution of the job, how can I change the query to the db offline Skipp and continue the job? ...
Score SQL 2005 Best Practices for backups
Richard Lawson - 18 Aug 2010 6:09 AM - 3 messages
I have been working on the conversion from SQL 2000 to SQL 2005 for best practices. I have come a long way. I only have 47 issues whcih I already knew. However, I am having trouble finding the best way to go from SIMPL to ...
Score Are there and Built-in Application Failover Technologies in .NET and/or Windows Server 2008 (or SQL
Charles - 16 Aug 2010 1:23 PM - 5 messages
Hi all A bit of a general question, hence the cross-posting. I have a .NET application running on a Windows Server 2008 server. For resilience, I want to run it on another server simultaneously, but only one instance of the application can be 'active' at any one time. In the event ...
Score Changing database collation for existing databases
JimLad - 11 Aug 2010 1:29 PM - 4 messages
Hi, We are upgrading from SQL2000 to SQL2008R2. We are taking the opportunity to update the collation on our databases. Sorry to bring this up again but there are a lot of partial answers online and a lot of conflicting information. Our situation is that we ...
Score help with a query...
RAB - 17 Aug 2010 11:48 AM - 2 messages
I need to create a complex query which gets data from 3 SQL tables. Table 1 - Department Dept_Id (int) primary key Dept_Name  (vchar) Include_Unavailable (bit) Table 2 - Employee Employ_Id (int) primary key Dept_Id (int) foreign key Employ_Name (vchar) Table 3 - Schedule ...
Score SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS
JimLad - 11 Aug 2010 4:34 PM - 4 messages
Hi, We have a large number of SQL 2000 databases having collation SQL_Latin1_General_CP1_CI_AS. We are now upgrading to SQL2008R2. I know that the default collation for 2008R2 British English is Latin1_General_CI_AS. One of our clients has indicated a preference for installing their new server with a default collation of ...
Score Log is out of space
Peter Afonin - 16 Aug 2010 4:16 PM - 4 messages
Hello, I'm running SQL Server Developer edition on Windows 7 Ultimate. Suddenly I cannot start the SQL server anymore. If I start the service manually, it starts then shuts down. The error log says: The transaction log for database 'model' is full. To find out why space in ...
Score Cannot delete a user due to reference by object Managefactorstate
The Corleones - 16 Aug 2010 10:22 PM - 3 messages
Hello everyone, I restored a db from SQL 2000 into SQL 2008.  I cannot delete a user, called tester', from Testdb-->security-->users.  Error msg is "Drop Failed for Schema 'tester'...cannot drop schema 'tester' because it is being referenced ...
Score Shrinking a transaction log file
bcap - 16 Aug 2010 7:51 PM - 4 messages
Hi, I am trying to better understand how and what happens when shrinking a transaction log file.  We use SQL Server 2005 and I have been asked to set the size of a database to 40MB, then if the database grows in ...
Score Move data from one server to another
Raj - 14 Aug 2010 7:10 PM - 5 messages
We are trying to move some databases from a set of old servers to a new servers and they are pretty large.. like around 100 databases and around 10-15 TB. They are all SAN connected and I believe SAN based replication from one SAN ...
Score help with a query...
RAB - 10 Aug 2010 10:02 PM - 3 messages
I have three tables Table1-Dept Dept_Id  int (primKey) Dept_Name  vchar Table2-Employees Employ_Id int (primkey) Dept_Id  int (forgeinKey) Employ_Name  vchar Table3-Schedule Schedule_Id  int (primkey) Employ_Id int (forgeinKey) Schedule_Date  datetime I want to do a query that will get the "Dept_Name" and all the ...
Score Report Services KPI
Jan Waiz - 10 Aug 2010 2:48 PM - 2 messages
Hi All, working with a SQL-Server 2005 i have a problem generating indicators (like kpi) on current dynamic data. Let me describe: Given is a dataset as this: Supplier    Year     Amount --------    -----      -------- ...
Score Remove Duplicate Rows
Muhammad Bilal - 25 Apr 2010 12:23 PM - 6 messages
Hi. I want to remove duplicate rows from a table in sql server 2000. Let I have a table1 with a column name which have duplicate values Name         John John John Tony Tony ...
Score Weekly Maintenance Plan
childofthe1980s - 10 Aug 2010 11:14 AM - 5 messages
Hello: The weekly maintenance plan that runs every week on Sunday morning in SQL 2005 failed for the first time in two years.  The SQL error log stated: "Problems with the query, "ResultSet" property not set correctly, parameters not set ...
Score alter column - changing nullability
Lars Tafjord - 9 Aug 2010 12:07 PM - 3 messages
A variable length column need to change its nullability property: alter table T alter column c varchar(5000) not null; The length of 5000 is not changed. Changing a column's nullability to disallow NULLs, should imply a scan of ...
Score SQL Server 2008 R2 Native Client backward-compatible to SQL 2005/2008??
tom12010 - 6 Aug 2010 1:48 PM - 3 messages
We have several different SQL Server versions in our datacenter, with SQL Native Client 9.00.1399.06 on our Citrix servers. The above SQL Native Client goes with our Great Plains app client, it's possible we will have a new, higher-level SQL Native Client ...
Score data analyst job profile
evergreenyellow_20008 - 8 Aug 2010 3:24 PM - 3 messages
i searched a job in sql server but i got a job as data analyst in one bpo. The work was like just copying and pasting the sql queries. I want to know is this IT related job or a bpo related. Does data analyst ...
Score select with subquery in select clause
jrchaveztj - 7 Aug 2010 5:10 PM - 2 messages
Hi I need to make a select from 2 tables whit this layout always with the newest datetime exchange currency. The local cuurency is Mexican Pesos Table 1 Currencies example: CurrencyID Key Description 1 USD USA Dollar 2 EUR European Euro ...
Score get number of monday, tuesday,... between 2 dates
Racsus - 29 Jul 2010 8:42 AM - 4 messages
Hi, how can I get number of monday, tuesday,... between 2 dates? Thanks, ...
Score How much memory should be free on a Server with SQL Server installed?
Abraham_Ocón_C. - 5 Aug 2010 9:28 AM - 3 messages
I am the new DBA in a company and I see that their production server has between 90 and 95% of memory been used. The problem is that according to the task manager, is not SQL Server or related services ...
Score Primary records with dependent as columns
Dotnet Developer - 4 Aug 2010 9:58 AM - 2 messages
I have a query to fetch primary with all dependents that gives me result as: ID Primary Name      depId DepName              Dep DOB                     ...
Score linked servers between different sql versions??
tom12010 - 4 Aug 2010 2:55 PM - 5 messages
Can a SQL Server 2008 server have a linked server that is SQL Server 2008 R2?? We presently use a SQL Server 2008 for reporting which links to a SQL 2005 server that will be replaced by a SQL 2008 R2 server, we need to ...
Score SEarching for records with unwanted unicode "blob" in text
mike.kolling@gmail.com - 3 Aug 2010 3:14 PM - 4 messages
Hi We have an unknown  number of records which contain a Unicode (65533) character in a text address field. Ie a "�" We need to removed these blobs. For a specific row I have done this SQL Select... ...
Score Decode XML Data Type
Charles - 3 Aug 2010 10:45 PM - 5 messages
I have something like the following: declare @msg xml set @msg = '<Message><SubItem>Some Text</SubItem></Message>' I'd like to be able to extract the value of the SubItem node, but I can't ...
Score Cascade delete
Mounilk - 2 Aug 2010 6:24 AM - 4 messages
Hi, I need to find out if the cascade delete option is set on any of the tables in my database. Any help is greatly appreciated. Cheers Mounilk ...
Score PROBLEMS TO MODIFY USER BBDD MIGRATED !!!!
Pedro Juan - 27 Jul 2010 12:01 PM - 11 messages
I made a backup with sqlserver 2000 and then perform a restore on SQLServer2005 and all right but once done all this I can not change anything. Why? why can not change anyting on the resoresd database ? Thanks and kind Regards. ...
Score Linked server query
hayko98 - 26 Jul 2010 10:34 PM - 14 messages
Hi, We have 2 servers: PRD and DEV (PRD has 2 extra weeks of data).This is my query: SELECT COUNT(*) FROM PRD_SERVER_name.PRD_DB_name.dbo.PRD_TABLE_name. When I connect to DEV Server and run this query, I am getting results ...
Score I/O error every night at 10 pm, why??
tom12010 - 28 Jul 2010 1:08 PM - 5 messages
Every night at about 10 pm (2000 hours) on our SQL 2005 since about 7/21 or so we have got this recurring error in our SQL server logs: 07/22/2010 22:00:34,spid2s,Unknown,SQL Server has encountered 1 ...
Score SQL server 2008 64 bit
Mecn - 29 Jul 2010 6:56 PM - 7 messages
Hi, Does anyone know the diff between SQL2008 32 bit adn 64 bit. What kind of situation the we need to have WIN 64 bit + sql server 64 bit? Thanks, ...
Score Need to truncate a transaction log
Rich Lawson - 28 Jul 2010 4:59 PM - 5 messages
I have a database which is 2 GB but the log file has grown to 35 GB. I would like to truncate the log so I set the recovery method to SIMPLE but the log file did not truncate after last night's backup. ...
Score Spurious data being inserted in field
Mike Myers - 21 Jul 2010 4:24 PM - 15 messages
Hello Periodically, some of the records in one table have one field updated to the following value:     <!--<1586567094>--> It is the most bizarre thing I have ever seen.  We have checked all our ...
Score Logical proof of SQL change - HELP please!
Edward - 27 Jul 2010 3:47 PM - 3 messages
See DDL below. This represents a very simplistic view of my client's system, in which there are actually about 95 tables and nearly 50 views.  The views are used primarily to provide a real-time snapshot of certain datasets for ...
Score Maintenance Plans in SQL 2005
RG - 27 Jul 2010 4:25 PM - 4 messages
I have 3 jobs in My maintenance plan.  The jobs are connected by precedence constraints.   In each case, the constraint is set to completion.  It appears that all the jobs are being executed at the same time.  My goal is to execute ...
Score SQL 2005 DB Space Allocation
RG - 23 Jul 2010 4:01 AM - 10 messages
I have a db which originally occupied 80 gig.  I have deleted 80% of the rows in the db.  After, I ran reindex and defrag.  However, the db space usage is at 89%.  I expected that the usage should be at 15% at most.  What ...
Score Automated way to discover the structure of the result set of a stored procedure?
Behzad Sadeghi - 25 Jul 2010 11:46 AM - 7 messages
Is it possible to write a script that, as its input, takes the name of a stored procedure, and, as its output, produces a table each of whose rows contains the name and data type of each column in the (presumably ...
Score Simple recovery database bloating?
Bero - 24 Jul 2010 1:59 AM - 9 messages
I have a several hundred GB simple recovery dev database bloats by 200-300 GB and does not release the free space to the OS. Sometimes drive runs out of space because of this. I had to shrink database every few months to bring back database to its size and release the ...
Score Rebuild Index errors via SQL2K5 agent job?
Bero - 21 Jul 2010 8:46 PM - 5 messages
I have done a rebuild indexes using a new stored procedure (with a cursor) for some of the user databases via SQL agent and it failed after few hours. It gives me this msg.. " Executed as a user:.... Incorrect syntax near the key word user. ...
Score Too Many Statistics Objects?
Behzad Sadeghi - 23 Jul 2010 1:25 AM - 5 messages
I just signed up with a client to help them with the performance of their SQL Server 2005 application. A check of sys.indexes on their database revealed one table with some 700 statistics objects and another with over 400. All the statistics objects appear to have been ...
Score SQL Server Performance Issue
Malkesh - 21 Jul 2010 10:12 PM - 7 messages
Hi All, Since last 2-3 weeks, our system has been experiencing issue of deadlocks and slow performance. The configuration is SQL Server 2005 SP3 64 bit Standard edition with 8 processor and 64 GB RAM (57 GB for SQL Server). Though it is not required but ...
Score bcp format file - error SQLState HY000, NativeError = 0,IO
Mitchell_Collen via SQLMonster.com - 21 Jul 2010 4:18 PM - 4 messages
Hi SQL Monsters I am having an issue using the format file that I generated using bcp. I am using SQL Server 2005. I cannot figure out why it doesn't want to import anything in based on its own bcp formatted file. Please look at what I am ...
Score MSSQL$SQLEXPRESS
MN - 21 Jul 2010 8:02 PM - 4 messages
Hi, Could you give me an advice what are different between MSSQL$SQLEXPRESS and MSSQL SQLEXPRESS? Sorry I am not good memory :"( Thank you all. ...
Score Backup Behavior
cbrichards via SQLMonster.com - 14 Jul 2010 8:42 PM - 5 messages
I am limited in my testing environment, so I am trying to validate my findings via this post. I am trying to understand: (1) if the size of the log file affects backups? (2) if the free space in the log file affects backups? ...
Score tables of the view
Miguel F - 21 Jul 2010 1:39 AM - 4 messages
as I can find the tables have a view? that is, if I have "select * from vFacturas" how I can find the fields and tables for each field? thanks ...
Score UDF: select field by its string name
Passiday - 19 Jul 2010 5:25 PM - 6 messages
Hello, I am looking for a way how to select field value, if the table and field name both are available as string parameters. I am aware that in SP it could be done, by using exec function. I am ...
Score Paging Size set up for sql 2005 best performance
DoleBludger - 14 Jul 2010 2:40 PM - 6 messages
erver windows 2003 sp1. 64 bits, Paging file size for selected drive C is (custom selected) Initial 2046 MB, and maximum 4092 MB. It is currently allocated 4081 MB. Computer RAM memory is 8GB. Server functions as a database MS SQL 2005 server, and it is used under ...
Score Determining T-SQL within a transaction_id
Rubens - 12 Jul 2010 2:01 PM - 5 messages
Is there a simple way of determining the actual T-SQL being executed in the current transaction_id? The code below displays the active transaction_id, but I'd like to quickly and easily see what it's actually running. Thanks, Rubens ...
Score column based auditing?
Craig Lister - 5 Jul 2010 1:02 AM - 8 messages
Hi guys. On a previous project, the requirement was just to store who updated a row, and when. So, we have a: created_date, created_user_id, modified_date and modified_user_id However, phase 2 of this project - they want to know which fields in ...
Score Index Rebuild and Statistics
cbrichards via SQLMonster.com - 14 Jul 2010 10:23 PM - 8 messages
When an index is rebuilt are: (1) statistics updated on the index during the rebuild process, or (2) is a flag set so that when the index is used next the statistics are updated on the index, or (3) if auto update stats is enabled the statistics are next updated when the ...
Score How to combine two identically structured tables to query them
Siv - 15 Jul 2010 3:38 PM - 4 messages
Hi, I am sure there is a way that you can have a query that effectively takes two separate tables that have the identical column layout and add them together and then perofrm a query on the combined set of data. I just can't ...
Score Distributed Transaction on SQL 2005
RG - 14 Jul 2010 2:40 PM - 6 messages
A stored procedure running from server A database db1 updates both local tables, as well as, remote ones, on server B database db2 via a db link.  All updates are part of the same distributed transaction. I have got it to work on one server.  In other words, I have made all ...
Score Provider: Named Pipes Provider, error: 40 & error 53?????????????
SAFEKOM - 13 Jul 2010 5:00 PM - 11 messages
Problem: How can I access SQL server on WAN???????????????????????????????? ----------------------------------------------------------- Error: (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) ------------------------------------------------------------------------ Information: Windows Sever 2008 (64bit OS) Service Pack 2 Microsoft SQL 2008 Server Management Studio (10.0)(64bit) ...
Score database integrity checks failing
SQL Programmer - 14 Jul 2010 2:40 PM - 4 messages
Hello: We have two database integrity checks jobs in SQL 2005 that are failing.  One job is for our financial app databases, while the other is for the SQL system databases. I know how to conduct the typical fix for the financial app databases--run ...
Score SQL Server cannot connect
ken - 5 Jul 2010 7:49 AM - 10 messages
Hi All, we found that the sql server can't connect and the log show below message, but we haven't do any shutdown action before, but the physical available memory is 1% at that time, anyone know that if the available memoery not ...
Score SQL Server 2000 - Maintenance Plan Fail errors
. - 2 Jul 2010 12:15 AM - 7 messages
Hello, after completing the Mainentance Plan wizard in which the Integrity Checks and Transaction Log Backup job fail I came across this [link] mentioning of the SIMPLE Recovery mode is hindering it.  Think I'm missing something...so does anyone know how ...
Score Query Help for Newb
sqlnewb - 12 Jul 2010 2:32 PM - 3 messages
All, I am a sql newb and in a bind and all out of ideas at the moment but I was thrown into figuring a query out to report back what my manager wants to see. Basically I have a table similar to the one below that I need to write a ...
Score Cannot Delete Maintenance Plans - SQL 2005
Randy H - 5 Oct 2006 7:41 PM - 6 messages
A consultant created a maintenance plan that isn't in use and is not enabled.  I want to delete the plan but get the following error. TITLE: Microsoft SQL Server Management Studio ------------------------------ Drop failed for Job 'Maintenance II'.  (Microsoft.SqlServer.Smo) ...
Score Views using linked tables
LAM - 8 Jul 2010 3:13 PM - 4 messages
Hi! On my own sqlDB, I need to link tables form other sqlDB in the same machine and then, create views that combine fields of my own tables and linked tables. Please give some suggestions. Thanks LAM ...

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