I got a server that Crashed. My network group was able to get it up and running but it's vary fragile. One of the disk is done. What's the best way to get the my database:tables,views,stored procedured,dts packages, jobs off the bad server without crashing it again? I used the databae copy utility but found out that some of the database are replicated and it wont allow it to copy.
Thanks
Just another day in the life of a dba
Hello All
Firstly thanks a lot Phil and Jamie on such a helpful article on "Checking to see if a record exists and if so update else insert"
Here is my question
I have about 10 tables and there respective working tables
For examples: A, B, C, D, E.... and WorkA, WorkB, WorkC....
Notes:
1) When I execute a package these work table (Work A, WorkB ...) get populated with certain rows say about 5
2) Its not that all the work table are populated on every execution.
3) Tables A, B, C... have thousands of records in it.
4) Work table is of same structure as there parent table..Like WorkA same structure as A.....
5) The table A and WorkA and as on... are linked with a KeyID
Now I want to build a SSIS package that can
1) Get the the data from these multiple tables(WorkA, WorkB...)
2) Process each row of these tables WorkA, WorkB..
3) Depending upon the KEYID of WorkA., WorkB.. etc Update a Flag colunm of table A, B...where the KeyID is equal to KeyID of Work Table
4) After updating insert that processed row of Work A, WorkB ...into Table A, B..
I can do this if I have one source table and one destination table. Here i have some say 10 randomly source tables to respective random destination .
All I could think of creating 10 different packages as adviced in Jamie's article. But I am sure there might some other alternative.
Can somebody advice me the best practice of doing this. Thanks a lot in advance
I understand SQL Express has a database size limit of 4G, but I read some forum correspondence here saying the 4G is a per database limitation, and within the Express instance, it can have multiple database of 4G in size.
I create multiple database and got an error saying size limit reached for the primary filegroup. Does that mean the 4G limits apply to the total database size ?
KL
I am running SMS ontop of SQL 7. I keep getting these SQL dump files and cant figure out where to begin. Can somebody help and put me on the right path?
2001-07-22 12:08:55.46 spid12 Process ID 12 attempting to unlock unowned resource PAG: 7:1:507423..
2001-07-22 12:13:21.29 spid8 Error: 1203, Severity: 20, State: 1
2001-07-22 12:13:21.29 spid8 Process ID 8 attempting to unlock unowned resource PAG: 7:1:505802..
2001-07-22 15:15:48.20 spid11 Using 'sqlimage.dll' version '4.0.5'
Dump thread - spid = 11, PSS = 0x700634b4, EC = 0x216da084
Stack Dump being sent to D:MSSQL7logSQL02866.dmp
************************************************** *****************************
*
* BEGIN STACK DUMP:
* 07/22/01 15:16:00 spid 11
*
* Input Buffer 417 bytes -
* INSERT INTO Summarizers_Status (SiteCode, MessageDLL, MessageID, Status,
* Updated, GUID_ID) SELECT DISTINCT SiteCode, "SMS_RES1.DLL", 40, (SELECT
* ISNULL(MAX(x.Status), 0) FROM Summarizer_SiteSystem x WHERE x.SiteCode
* = a.SiteCode), (SELECT ISNULL(MAX(x.TimeReported), '1/1/1998 01:00') FRO
* M Summarizer_SiteSystem x WHERE x.SiteCode = a.SiteCode), "{78B42510-ABB
* D-11d1-BB12-3A84C6000000}" FROM Summarizer_SiteSystem a
*
************************************************** *****************************
-------------------------------------------------------------------------------
Short Stack Dump
0x77f67a6b Module(ntdll+7a6b) (ZwGetContextThread+b)
0x00784f83 Module(sqlservr+384f83) (utassert_fail+19f)
0x005b572c Module(sqlservr+1b572c) (ExecutionContext::Cleanup+9d)
0x004eb421 Module(sqlservr+eb421) (ExecutionContext::Purge+45)
0x004eb182 Module(sqlservr+eb182) (stopsubprocess+e5)
0x004e9d4e Module(sqlservr+e9d4e) (subproc_main+174)
0x41092a47 Module(ums+2a47) (ProcessWorkRequests+ec)
0x4109326b Module(ums+326b) (ThreadStartRoutine+138)
0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce)
0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be)
2001-07-22 15:16:01.24 kernel SQL Server Assertion: File: <proc.c>, line=1927
Failed Assertion = 'm_activeSdesList.Head () == NULL'.
2001-07-22 15:16:01.31 spid11 Using 'sqlimage.dll' version '4.0.5'
Dump thread - spid = 11, PSS = 0x700634b4, EC = 0x216da084
Stack Dump being sent to D:MSSQL7logSQL02867.dmp
Help!!!
our sql server (7.0) crashed today because it's running out of space, apparently as a result of some process(es) loading data onto it that left less than one mb of free space on the C/ drive. Most of the data and backups are on the D/ drive which has tons of free space. The swap file was on C/ but the dba moved it after today's episode. His diagnosis is that there are files being created in the server's cache that are clogging it up.
What I really need to find out if there are any temp files generated by scheduled packages that could cause this to happen? We are relatively new to executing jobs on the sql server, so this was not an anticipated situation. Essentially, this server has about 12 jobs that import and transform data from an AS/400 server onto the SQL Server every week. We've been running the jobs for about 4 months and just about 3 weeks ago I noticed a big degradation in the server's performance. Also, how can I find out which physical drive the jobs are residing on? Could anyone suggest on the best course of action please?
Irene
out if there are some sort of temp files that are generated when the scheduler executes jobs on the server.
Hi All
Last to last friday, the server crashed.We had to restart the machine to bring up the sql server.Initially we thought this as a one odd instance.This friday, almost the same time, it crashed again. By the time users complained saying they are not able to acces the application, the server froze.I was not able to see the processes running during this time.
Now I realised there is a potential problem.
I check all the logs - > SQL Server log, SQL Agent log, Event viewer.
I dont see any error messages related to this.
Since both weekends it happened at the same time, I assume that there might be some job running on the friday evening which is bringing the server down.
I checked for all the scheduled jobs and didnt find anything. So I assume this might be because of some adhoc jobs ran from the application which is causing this issue.
This have been highly escalated by the users and I have to act :mad:
I am planning to put a trace to see the happenings during this time.
Questions
1) What all parameters(in the profiler) should i take into consideration
2) Any other ways of troubleshooting the same.
3) Any whitepapers / documents to similar issues
Plz respond,my job is at stake :(
Thanks
Sree
Please direct me to detailed causes of SQL server crashing after a 17805 Invalid Buffer Received From Client. Our production server goes down, following this msg.
We applied service pack 5a, and it is still crashing. It crashes using either NAMED PIPES or TCP/IP protocol (via ODBC) The driver versions are older, ODBC 3.0 and SQL Server 2.65, respectively.
I need some direction on this. I'm leaning towards the possibility that this is an application problem.
Any help, any configuration setting changes, upgrades, workarounds, will be accepted. Thank you much!
Hi
We're having trouble with Enterprise manager when trying to view views or table data/properties, we get an access violation error and the database crashes sometimes corrupting tables.
Ive seen some posts stating a post SP3 for SQL Server is required and some posts saying client access should be modfied.
However our enterprise manager clients are registered with SA so I dont think that is an issue.
Can anyone give me some help with this and/or direct me to the hotfix please.
Cheers
Louise
i have my SQL server 2005 crashing when Events log is full
I have a hacker attacking my DB with a brut force tool but whereas he does not have the password, event log registers his access attempts as Failure Audit.
I have thousands of lines of "Failure Audit" in my event log
The event logs are set to be overwritten automatically when they reach 16Mb but it's not working correctly, they r not overwriting their content.
in SQL 2005 ERRORLOG file i see:
2007-05-14 01:57:11.57 spid80 Error: 17054, Severity: 16, State: 1.
2007-05-14 01:57:11.57 spid80 The current event was not reported to the Windows Events log. Operating system error = 1502(The event log file is full.). You may need to clear the Windows Events log if it is full.
SQL Agent cannot starts because it's not able to write in the event log that it's starting and when it cannot write in event log, it does not start and my sql server crashed
My Question is simply how to fix this issue once for all
I had the following erroneous code in a SQL Server stored C# procedure:
class P
{
private DateTime? e;
public P(
DateTime? e)
{
this.e= e;
}
public DateTime? E
{
get
{
return E; // correction return e;
}
set
{
E= value; // correction e = value;
}
}
}
Calling the getter of E of the class P creates an infinite number of method calls. This causes the .NET stack overflow. This sometimes caused our SQL crash. Here's the log:
29.3.2007 9:46:08 A fatal error occurred in .NET Framework runtime. The server is shutting down.
29.3.2007 9:46:10 Microsoft SQL Server 2005 - 9.00.2153.00 (X64)
May 9 2006 13:58:37
Copyright (c) 1988-2005 Microsoft Corporation
In my opinion an error in SQL server CLR stored procedure must not be able to crash the whole SQL Server, as it seems to do. Could someone verify this?
What makes finding problems like this problematic is that the only error is like ".NET stack overflow". No pointer to where in the code the error occured. It took hours for me to find the problem
Hello,
I want to load-balance my PDAs accessing my database to make a merge replication.
As I have one server with the SQL Server Mobile Server Tools installed, can I configure some of these PDAs to use another server with SQL Server Mobile Server Tools to point on the same Database server?
Is it going to work or will it generate problems?
Thanks for your help,
Ben.
I've installed the client tools on my notebook, and EM normally works properly. However, sometimes Enterprise Manager will crash on me for no obvious reason(it generates errors, but this takes forever, so i kill it). It is not consistent, nor can I reproduce the error, but it happens about once a day, never at the same time. Anyone else see this? My pc has win2K professional on it.
View 1 Replies View RelatedI just recently replaced my old HP laptop with a Sony VAIO. I installed all of my development software on it, including SQL Server 2005 and the studio. At some point when I am using the studio on this new laptop, if I try to resize any of the columns to better fit the data, it crashes my laptop. I get the infamous Blue Screen of Death.
The laptop is a Sony Vaio BX670P and it has Win XP SP2 with all of the latest and greatest updates loaded on it.
The BSD blames a driver for causing the crash and points out "win32k.exe" specifically. This has never happened to me before.
Does anyone know why this might be happening?
- - - -
- Will -
- - - -
http://www.strohlsitedesign.com
Hi,I'm accessing a pair of databases with ASP/ADO,and using stored procedures on the first access.The first access works OK - everything gets writtento where it's supposed to be.On attempting to write to a pair of database tablesin the second database (second access attempt),the server crashes, as does the app, and I get the following error:--------------------------------------------------------------------Server Error in '/Webfolder01' Application.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)--------------------------------------------------------------------After this, I have to go into the services panel and restart SQL 2005.This doesn't happen if I use small test data sets in the first access,and I can comment out the second access attempt, and the first accessexecutes just fine with both the large and small data sets,so I'm thinking that this has something to do with synchronisation:Perhaps the second attempt is being made before the server is ready.Is there something that I need to do to make certain that SQL 2005is ready to receive data?I'm using SqlBulkCopy with both accesses, but I don't see how thatcould be a problem.--------------------------------------------------------------------[SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857370 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734982 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) +556 System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) +164 System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) +34 System.Data.SqlClient.TdsParserStateObject.ReadBuffer() +30 System.Data.SqlClient.TdsParserStateObject.ReadByte() +17 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +59 System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal() +1327 System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer (Int32 columnCount) +916 System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState) +176 System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table) +6 Database_control.DB_ctrl_class.load_datatable_to_DB_table(DB_ref_class src_table) in i:Virtual WebfoldersDBctrl.cs:978--------------------------------------------------------------------THANK YOU VERY MUCH!!!
View 4 Replies View RelatedI'm having many many issues installing sql server management tools. i had visual studio 2005 installed first, but uninstalled and sql related things before trying to install sql server management tools again - i also deleted the program files/microsoft sql server/ folder so there are no references.
Firstly the system configuration check gives me a warning that the system doesn't meet the recommended hardware requirements - this is wrong... i've got 2.33Ghz dual core + 1gb of ram...
I select just management tools + client connectivity to install and click next -> the setup support files/native client/owc11 etc all install fine but workstation components etc fail and the setup log appears to either be empty and not available
and MSXML6 fails... after clicking finish the installer appears to crash - : "Microsoft SQL Server 2005 Setup has encountered a problem and needs to close. We are sorry for the inconvenience"... I have tried all sorts of variations on this install and have had no problems in the past - please help!
The setup log from the MSXML6 failure -
=== Verbose logging started: 18/03/2008 12:34:09 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (5C:78) [12:34:09:067]: Resetting cached policy values
MSI (c) (5C:78) [12:34:09:067]: Machine policy value 'Debug' is 0
MSI (c) (5C:78) [12:34:09:067]: ******* RunEngine:
******* Product: {AEB9948B-4FF2-47C9-990E-47014492A0FE}
******* Action:
******* CommandLine: **********
MSI (c) (5C:78) [12:34:09:067]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (5C:78) [12:34:09:067]: Grabbed execution mutex.
MSI (c) (5C:78) [12:34:09:067]: Cloaking enabled.
MSI (c) (5C:78) [12:34:09:067]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (5C:78) [12:34:09:067]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (28:E4) [12:34:09:113]: Grabbed execution mutex.
MSI (s) (28:74) [12:34:09:113]: Resetting cached policy values
MSI (s) (28:74) [12:34:09:113]: Machine policy value 'Debug' is 0
MSI (s) (28:74) [12:34:09:113]: ******* RunEngine:
******* Product: {AEB9948B-4FF2-47C9-990E-47014492A0FE}
******* Action:
******* CommandLine: **********
MSI (s) (28:74) [12:34:09:113]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (28:74) [12:34:09:113]: MainEngineThread is returning 1605
MSI (c) (5C:78) [12:34:09:113]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (5C:78) [12:34:09:113]: MainEngineThread is returning 1605
=== Verbose logging stopped: 18/03/2008 12:34:09 ===
The log summary:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Tue Mar 18 12:05:06 2008
EOC429 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
Machine : EOC429
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : EOC429
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : EOC429
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_OWC11_1.log
--------------------------------------------------------------------------------
Machine : EOC429
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_BackwardsCompat_1.log
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Tue Mar 18 12:19:20 2008
List of log files:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_Core(Local).log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SQLSupport_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SQLNCLI_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_OWC11_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_BackwardsCompat_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_MSXML6_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework 2.0 LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework Upgrade Advisor.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework Upgrade Advisor LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework Windows Installer.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework Windows Installer LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SNAC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_Support.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SCC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_WI.log
Hi there,
I have been at this problem for a few hours now using Net 2.0, and can't seem to find an answer.
I am using a asp:calendar that allows the user to pick multiple dates.
When the user is finished and hits the command button, I would like for those dates to be inserted into a table in my SQL DB called Dates.
The mutildate calendar works fine--, and I have placed all of the sates into an Array. And now have a loop for the array to print them out.
What I want to do, instead of printing, is insert them.
C anyone post some 2.0 code behind for insertion? I have found other "batch insert" code, but when I place in the VB, I get errors telling me it is no longer supported.
For example:
Dim sqlCon As New SqlConnection (no longer works in 2.0) since it doesn't recognize Sqlconnection.
Should I use a SqlDataSource? And if so, how do I prepare the Insert command for it?
Any and all help appreciated!
Hi Friends,
Is it Possible to combine two different dataset in a single rdl file ?
for example:
emp dept
eno enmae deptno deptno depatname
--------------------------- ----------------------------
1 x 10 10 computer
2 y 20 20 Testing
In RDL File out put will be
Eno Ename Deptname
------------------------------------
1 x computer
2 y Testing
PS : I am not used the join condition.
Thanks & Regards,
G.V.Senthilkumar
+91 9894017253.
Hi,
I have two tables one called students and location.
I want to delete the location and all records in student corrosponding to that location, can any help or point me in the right direction.
Many Thanks
I have a table like this.
Depositors Table
Value(int) StartDate(Date) AccountID(int)
I want to create a report from this table. the report should look like this.
Value No of Accounts Average Value
For Yesterday
For Last 7days
For Last 30 days
Please Can anyone write a simple query for this?
Thanks
Has anybody here seen and resolved the following error?
The MS DTC Transaction Manager is in an inconsistent state and cannot proceed. Please contact Microsoft Product Support. (null)
File: . mtx.cpp, Line: 2570.
We've had this just crop up on a server over the last week. Not finding a lot.
Hi All,
I'm relatively new to ASP.NET coming from ASP. I've created a new, relatively simple ASP.NET application using WebMatrix with various controls and pages accessing an SQL Server database.
3 people are trying to use this app. After a short amount of time, the server starts kicking back an error message that it can not open a connection. I go in with Enterprise Manager to the SQL Server and I can see a long list of processes there almost as if each page is opening a connection and not closing. I'm explicitly closing all connections in my code where I open them for use by a data reader. What about data grid controls. Do they leave connections open? How about the drag and drop insert/update/delete functions. Unless I'm mistaken, this should close the connection when the function completes, shouldn't it:
Try
rowsAffected = dbCommand.ExecuteNonQuery
Finally
dbConnection.Close
End Try
I originally did this app connecting to an Access database but had the same problem. I figured it was due to the known connection issues with Access via ADO so I upsized to SQL Server and over time, get this same problem.
Any help would be appreciated!
Thanks,
Larry
Not sure if the title describes my situation or not.
Simplified example is:
I have an [Employee] table with EmpCode, EmpName
I have a second table [NewHires] that has: HireDate, EmpCode, Addedby
Both EmpCode and Addedby contain EmpCode referring to the Employee table.
I wish an output similar to:
New Employee (from EmpCode in NewHire), Hired on (From HireDate), Hired By (from Addedby)
My problem is with an Employee.EmpCode=NewHires.Empcode or Employee.EmpCode=NewHires.Addedby in the Where clause or Join part of the SQL I don't know how to get EmpName from the Employee table twice but using two different EmpCode as the reference.
Thanks in advance - Shawn
I have a lookup table called States, I have multiple other tables that use this lookup table, but I can only relate to one other table. My question is if I change a state name how do I enforce that change to the other tables that CANT be related? I know it is a design flaw and need some kind of joining table. I am having difficulty understanding and incorporating first normal form in my database. Here is what i have so far.
Example:
Table 1
========|============|=============|========|
CustomerID BillingAddressID ShippingAddressID OtherFields
========|============|=============|========|
Table 2
===========|======|========|
BillingAddressID StateID OtherFields
===========|======|========|
Table 3
=============|======|========|
ShippingAddressID StateID OtherFields
=============|======|========|
Table 4
======|====|
StateID Name
======|====|
How do I relate table 4 with table 2 & 3 for referential integrity? Or create a joiner table?
Hi,very new to SQL queries, and strugling with join conceptI had to do a join based on a single field:select*fromtableA, tableBwheretableA.value = tableB.value(+);this works finebut how can i do the same thing while comparing multiple columns ... iwas thinking something like this: (obviously doesn't work)select*fromtableA, tableBwhere[tableA.value1, tableA.value2] = [tableB.value1,tableB.value2](+);Is there some sort of "tuple" comparison I can do?Thank you.
View 2 Replies View Relatedusing osql to apply SPs in mutiple threadsHello,I got a weird problem when I was using osql to apply scripts for msdedatabase in multiple threads mode. Sometime 2 sps were missing duringthe whole apply process, sometime not, and seems like only those twoSPs met the problem. No error was appeared. Did anyone meet sameproblem before? Or any possible solutions?Thank you very much!
View 4 Replies View RelatedI have about 100 different tables that I would like to bring on nightly basis via integration services. SSIS will process the data and send on to its warehouse destination.
Is it possible to use a single task to bring in all these tables from within SSIS? and can write failed records to flat files at the sametime? instead of defining a data flow for each table and dealing with hundreds of dataflows just have one task that loop through the list of tables.
Wonder how warehouses fed by 100s of tables deal with this kind of scenario?
Hi,
I am using a stored procedure to take backup of my database from the Visual Basic Programming.
Before i posted one of my thread with the same thing, so i was recommended to go through with DMOSQL do deal with SQL server with Visual Basic Programming. For me, this takes some time to understand the complete concept.
Because of urgent i am using stored procedure to take backup with the following:
---------------------------------------------------------------------------------------
ALTER PROCEDURE dbo.BackUPBLMSDB
(
@RP nvarchar(200)
)
AS
declare @backupfilename nvarchar(200)
set @backupfilename=@RP
BACKUP DATABASE [BLMSDB] TO DISK = @backupfilename WITH NOFORMAT, NOINIT, NAME = N'BLMSDB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
---------------------------------------------------------------------------------------
Example @RP="D:ackupBackup-1 09-02-2008 11-24"
Every time i am passing a parameter with somename and dateandtime(System).
Example
Backup-1 09-02-2008 11-24 2900KB
Backup-1 09-02-2008 12-30 2900KB
Backup-1 09-02-2008 18-10 5400KB
Backup-1 09-02-2008 22-00 2900KB
Backup-1 09-02-2008 22-00 2900KB
I would like to clear my doubt, is it a good practice to take backup with different names. The above one i store four backups . If the system crashes and i created the new database with the same schema without any data present in the tables, can i restore previous backup database to the newly created database.
Moreover, The first two backups contains "2900KB", the third one is "5400KB" after the data is being modified. Look at the fourth one it is "2900KB". Why the size is being reduced to "2900KB" after taking backup eventhough i didn't delete or added data into the database.
Hope you will solve my problem.
Thanks.
Best Regards,
Kashif Chotu
Has anybody had any problems with mmc crashing when running Enterprise Manager on SQL Server 7.0/SP1? This occurs on a fairly regular basis on several of our development NT client machines (NT SP4 and SP5). We are running Version 1.1 of mmc. Is there a later version (or service pack) we need to be using?
Any comments on this would be appreciated.
Thanks
:eek:
OK, I'm having fun here. I have 3 anonymous subscribers using merge replication all, including the server, on SQL 2000 Server SP3a.
2 of the 3 subscribers crash during the merge process, a Dr Watson error log comes up saying that the replmerg.exe has died.
I have checked for orphaned processes of the same name to no avail. Just in case I made a mistake, I rebooted the server to ensure that any orhpaned processes were killed. No Joy.
Does anyone have any idea what this would happen?
Hello,
I am trying to programatically create an SQL Server destination in SSIS. I am creating the connection string, then initiating a connection, and then call AcquireConnections(nothing).
When running in debug mode or in command line, all works perfect. However, when running from within a Windows Service, I get the following exception:
System.Runtime.InteropServices.COMException (0xC020801C): Exception from HRESULT: 0xC020801C at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.AcquireConnections(Object pTransaction) at ...
Any ideas ?
Thanks,
Hanan.
All of a sudden one of my projects/packages seems to have encountered a strange problem. First I tried to remove a data viewer which caused BIDS to crash and tell me that VS has encountered a problem and needs to close. This is repeatable every time I try to remove the data viewer or the link or the transforms or the entire data flow. How do I get around this besides starting from scratch and how do I figure out why this is happening and is there some fix?
thanks
John
Hi all,Is this at all possible? In the following query I have mutiple columns in my SELECT statement that each have their own alias. Is it possible that I can use just one Alias for all these columns (such as Address), and if so how is it done?SELECT RTRIM(ISNULL(ta.house_no_flat, '')) as [Target - Flat No.], LOWER(RTRIM(ISNULL(ta.building, ''))) as [Target - Building], LOWER(RTRIM(ISNULL(ta.road_street, ''))) as [Target - Street], LOWER(RTRIM(ISNULL(ta.district, ''))) as [Target - District], LOWER(RTRIM(ISNULL(ta.town, ''))) as [Target - Town], LOWER(RTRIM(ISNULL(ta.county, ''))) as [Target - County], RTRIM(ISNULL(ta.postcode, '')) as [Target - PostCode]ThanksTryst
View 2 Replies View RelatedIs it possible to count the same field with different criteria. It would be something like this.
car_table
car_id
car_name
car_brand
So you would execute a statement which would count(car_brand) with two different criteria.
I am not sure if this is possible or if there is another way to approach it.