Important
Jan 14, 2000hi, i have got 10 dts packages i want to create a job and put them all into that job. I could not execute the dts create in tsql. Can any one say as how to execute that in the job.
View 1 Replies
ADVERTISEMENT
Very Important
Oct 26, 2001The programmers encountered a problem as following:
Different programmers use the same account(Admin) to login to the same database to create table from different workstation. The tables were created through the same steps which is highlighted the Table folder -->New table then go through the wizard. The table were created successfully but the ownership were different. One with Admin as owner, the other has dbo as owner. Even Admin is the owner of the database but this created a problem for them that they need to specify differently for the tables depend on who created them.
what is the cause of this, sevice pack 3 is installed on the machine.
Its Sql Server 7.0
Thanks in advance.
RSVP
Important To Everyone In Sql 7.0
Feb 1, 2001Babu.G here,
Working as MS-SQL DBA IN MNC..I HAVE A DOUBT SO PLEASE
CLARIFY THAT..WHERE SHOULD I DECLARE GLOBAL VARIABLES..FOR EXAMPLE @@ROWCOUNT AND MANY..
LIKE THAT I NEED TO DO..
IN CASE IF I AM DECLARING ONE @@GLOBAL VARIABLE IN PROC AND STORING SOME VALUES IN THAT
IF CALLED THAT VARIABLE INTO SOMEOTHER PROC ..IT IS GIVING ERROR..
PLEASE TELL ME..
BABU.G
Thanks in advance
Important Question...
Aug 14, 2005hey people...
im currently using sql server 2000... is there a datatype or a way so
that you dont have to limit the length that a user can enter into a
textbox (for example) that will be saved in a column in a table in sql
server?
thanks!
Very Important -- Urgent
Oct 15, 2001I'm in deep problem...please help...
There was someone who got into the system and modified the database properties to DBO use only..what we want to do is to track such changes with when they did.
As like what happened earlier..some told me about turning the audit level to all will help but it does not give the information about who has did and what did they do...
Is there a way in which we can find out what happened and who did this what command they have executed...
Thanks..i appreciate your help..
Mitchell
Query Help - Important
Oct 17, 2001Hello I have the following query set up and I am getting the errors of: Any help on this would be appreciated.
Thanks
Stuck !
Server: Msg 107, Level 16, State 3, Line 2
The column prefix 'TEAM3B_PULL_TOTAL_TST' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Line 2
The column prefix 'BUS_REQ_DESCRIPTION_TST' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Line 10
The column prefix 'TEAM3B_PULL_TOTAL_TST' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Line 10
The column prefix 'BUS_REQ_DESCRIPTION_TST' does not match with a table name or alias name used in the query.
Select REQUEST,BUSINESS_REQ_ID,TEST_CASE_SOURCE as SOURCE from TEAM3B_PULL_TOTAL_TST
if TEAM3B_PULL_TOTAL_TST.REQUEST<>BUS_REQ_DESCRIPTION_TST.REQUEST
begin
Insert into TEST_REPORT.dbo.BUS_REQ_DESCRIPTION_TST(request,bu siness_req_id,source)
select request,business_req_id,test_case_source as source
from TEAM3B_PULL_TOTAL_TST
end
Else
begin
if TEAM3B_PULL_TOTAL_TST.REQUEST=BUS_REQ_DESCRIPTION_ TST.REQUEST
begin
Insert into TEST_REPORT.dbo.RDD_UPDATE_TST(request,business_re q_id,test_case_id,test_case_descr)
select request,business_req_id,test_case_id,test_case_des cr from TEST_REPORT.dbo.TEAM3B_PULL_TOTAL_TST
order by TEAM3B_PULL_TOTAL_TST.REQUEST,TEAM3B_PULL_TOTAL_TS T.BUSINESS_REQ_ID,TEAM3B_PULL_TOTAL_TST.TEST_CASE_ ID
end
end
Error Please Help - Important
Oct 22, 2001Hello,
When I try to run the following query:
if (select REQUEST from TEST_REPORT.dbo.TEAM3B_PULL_TOTAL_TST) Not In(select REQUEST from TEST_REPORT.dbo.REQUEST_BUS_REQ_TST)
begin
Insert into TEST_REPORT.dbo.REQUEST_BUS_REQ_TST (b.request,b.business_req_id,b.bus_test,b.test_cas e_id,b.test_case_source,b.test_case_descr)
select a.request,a.business_req_id,a.bus_test,a.test_case _id,a.test_case_source,a.test_case as test_case_description
from TEST_REPORT.dbo.TEAM3B_PULL_TOTAL_TST AS A INNER JOIN TEST_REPORT.dbo.REQUEST_BUS_REQ_TST AS B ON A.REQUEST = B.REQUEST
Order by REQUEST,BUSINESS_REQ_ID,TEST_CASE_ID
end
I am getting the error messages of:
Ambiguous column name 'REQUEST'.
Ambiguous column name 'BUSINESS_REQ_ID'.
Ambiguous column name 'TEST_CASE_ID'.
What is wrong in the above statement?
Thank you,
Important Question
Nov 30, 2007I am given to install ODBC drivers in two servers and main thing is they are clustered . SO do i have to install in both servers or CLuster will configure that. Urgent help please . Thanks
View 8 Replies View Related65, 70 Client Issues--important
Jun 23, 2000hi,
I am recently upgraded to sql 7.0, my clients are having 6.5 and 7.0 versions means we are still having some 65 servers.
When they try to connect to new 70 server it is saying ''login failed''.
I think it is trying to connect to old sql 65 version, what i have to do to connect to sql70 for clients..
They are having both 7.0 and 6.5 servers.
Can anyone pls assist me regarding this.
Thank u very much
--Ramu
An Important ODBC Problem
Jan 14, 2000Dear friends,
After installing visual interdev, on a webserver (nt4.0 ent server),
whenever I was trying to configure the DSN on the ODBC settings, It gives
" The ODBC resource DLL (C:WINNTSYSTEM32odbcint.dll)is a different
vaersion than the ODBC setup dll(c:winntsystem32odbccp32.dll)
you need to reinstall the ODBC components to ensure proper operation." error msg.
I thought of removing all the ODBC drivers and reinstlling the odbc drivers came with NT SERVER. I don't know how to do it. If anyone knows how to do it, can you please post it. Thanks a lot.
Lose Important Data
May 16, 2007Hi all,
I have some problem :
I use sql server 2000,I have about 20000 records !
I delete all data unfortunately !
So , i need to restore all .
Are there way to do this ? I don't setup automatic backup !
My data is very important !
Thank you very much.
So Important Feature Has So Many Bugs!
Mar 20, 2008I tried SQL mirroring in beta 1 , then it was gone, until SP1.
Now I can not setup mirror, it is fine if it is just hard to setup, but it seems it is full of bug! The mirroring has to be stable, since I am trying to mirror product db, what a diaster if something goes wrong.
I am trying two servers, both has 9.0.3042. First I tried to setup on my home machine, I VPN to my network, After I config security, I see two connection strings:
TCP://sql8.mydomain.netsql2005:5022
TCP://sql5.mydomain.netsql2005:5022
and I click start mirroring, then I got error - Alter failed due to invalid connection string. Hard to figure it out, right?
Then I tried the same thing on a server in the network, this time I get
TCP://sql8.mydomain.net:5022
TCP://sql5.mydomain.net:5022
and it doesn't show that error anymore, I am not sure why the connection should be like the latter format, but in anyway, how come SMO can not make it right?
then I get another error, SQL server doesn't exist or can not access, I search on the Internet, it seems that error could mean anything, include that the mirror db is not in restore mode.
But I did set the mirror db in restore mode and both sql5 and sql8 are under same domain, pysically close.
So what else I can check?
Any suggestion?
thanks
Password Field (very Important)
Feb 20, 2006A collegue from me used the MySQL database before (I haven't done this before). He asked me, if it is possible to store a MD5 hash in a cell.
He telled me that MySQL has got a special function wich computes the hash value. Can someone help me?
Thanks for help
Important: SSIS Failure On 64 Bit.
Jul 28, 2006Our SSIS package suddenly stopped loading. We have 64 bit server on which we run SSIS packages. We had problem "script task failed to load" so we started to use the 32-bit version of dtexec to run the packages. Package used to run fine.
Today we upgraded our server to Sp1 and 2153 hot fix (x64) and now the package have stopped to load.
we confirmed that the issue is not as inthe KB below:
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B918038
We are still using the 32-bit version of DTExec(as in SQLx86). With 64 bit we get the error "script faield to load". we are going to fix the script failed to load error but, we need help to get going right now.
help would be greatly appreciated
Message:-
Executed as user: PHX\_IDSS-OPS. ... Package Utility Version 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:13:48 AM Error: 2006-07-28 01:14:50.11 Code: 0xC0010018 Source: Description: Error loading value "<DTS:LogProvider xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:Property DTS:Name="ConfigString">AdCenterExtractionLog</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">SSIS log provider for Text f" from node "DTS:LogProvider". End Error Could not load package "D:adcenterDWApplicationBINACDWExtraction.dtsx" because of error 0xC0010014. Description: The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails. Source: . The step failed.
An Important Question? MSSQL/IIS4.0
Dec 20, 1999Dear Friends,
I have a IIS 4.0 server ( configured as virtual multi servers), and a sql server containing multiple databases.
each virtual server should access a unique database on the sqlserver.
How can we configure this setup on both servers?
Note:the owner of each multi server (dbo)will own a unique database. they are bound to only with theirs database only.
Please help me on this issue?
Thank you all and Happy holidays!!!!!
An Important Question Regarding MSSQL/IIS4.0
Dec 20, 1999Dear Friends,
I have a IIS 4.0 server ( configured as virtual multi servers), and a sql server containing multiple databases.
each virtual server should access a unique database on the sqlserver.
How can we configure this setup on both servers?
Note:the owner of each multi server (dbo)will own a unique database. they are bound to only with theirs database only.
Please help me on this issue?
Thank you all and Happy holidays!!!!!
Kind Of Important. Connection String
Nov 20, 2006I am having a problem getting into SQL 2005.
My connection string is as follows:
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection(@"Provider=SqlOleDb;Data Source=Orange;Initial Catalog=Test;");
//tried with taking out comma after Test as well.
I have tried a lot of different permutations here and I cannot get this to work.
Maintenance Plan - Order Important?
May 8, 2008Hi, I'm configuring a maintenance plan for my SQL Server 2005. Is the order of things important here? I can't seem to find any best practices for this anywhere.
Obscurr
Decreasing Number Of Records.. Is It Important?
Jul 20, 2005hi,If we consider the following scenerio:a school with 500 students.On average student takes [x] courses per year, and [y] tests per course.table of grades:+------------+-----------+---------+-------+| student_id | course_id | term_id | grade |+------------+-----------+---------+-------+| | | | |+------------+-----------+---------+-------+| | | | |+------------+-----------+---------+-------+as average, x = 20, y =6 thennumber of records = 500 * 20 * 6 = 120,000 record per year.is this design correct considering number of records generated per year?Is it important to reduce the "number of records" or no?thank you.
View 1 Replies View RelatedImportant Information About Microsoft Exams
Jun 2, 2008There are twelve more exams will retire on March 31st, 2009. Microsoft has announced this information. These exams focus on technologies will be no longer included in Microsoft mainstream support. The exams are currently required to achieve Microsoft Certified Application Developer (MCAD), Microsoft Certified Solution Developer (MCSD), and Microsoft Certified Database Administrator (MCDBA) certifications.
Details:
Developer exams that retire on March 31, 2009
’ Exam 70-300: Analyzing Requirements and Defining Microsoft .NET Solution Architectures
’ Exam 70-301: Managing, Organizing, and Delivering IT Projects by Using Microsoft Solutions Framework 3.0
’ Exam 70-305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
’ Exam 70-306: Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
’ Exam 70-310: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
’ Exam 70-315: Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
’ Exam 70-316: Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
’ Exam 70-320: Developing XML Web Services and Server Components with Microsoft Visual C# and the Microsoft .NET Framework
’ Exam 70-330: Implementing Security for Applications with Microsoft Visual Basic .NET
’ Exam 70-340: Implementing Security for Applications with Microsoft Visual C# .NET
Microsoft SQL Server exams that retire on March 31, 2009
’ Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
’ Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
This article is quoted from microsoft.com.
Very Important Question About SQL Express And SSIS
Mar 14, 2006We're developing a WinForm app that is being deployed via ClickOnce. The application will have the ability to import/export data with the intention of this being done via SSIS. When this app is deployed and run against SQL Express, the following error gets generated:
Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to error: 80040154?.
Is SSIS functionality supported in SQL Express?
Duplicate A Same List On The Every Page (important)
Feb 20, 2008Hi everyone, I have a question. We need to create a server report to display a one product's information at the left (datasource with a one ID of selected product) and other products to compare at the right (second datasource with N of IDs of products to compare). The problem is how to duplicate the first List element with selected product on the every page (by default it renders only on the first page)? Any ideas?
View 3 Replies View RelatedConnection To SQL Server Failed ... *important, Need Urgent Help*
Jan 14, 2008Hello everyone, I've been searching the forum for three hours now and I couldn't find anything that helped me.
First I thought I didn't install the SQL server properly, I now found out that it is installed properly.
I am using VWD 2008 Express Edition. I could access the aspnetdb in the SQLExpress server. I could modify entries and create new databases. So the server obviously works.
Problem -> I cannot access the WebSiteAdmin modul ... for no apparent reason, it always gives me a timeout.
If you restart the tool by clicking the asp.net icon in the traylist stop it, then retry over the button in the VWD, then I did that a dozen times. I restart the tool and then access it five seconds later, no matter what I do I always get a time out.
Any help is appreciated, I can't solve this and I really really need it. Thanks a lot in advance.
Disk Activity Audit - Important Metrics??
Apr 19, 2004Hello All,
I am trying to perform a performance audit on a SQL Server where I am positive my most likely bottle neck is the disks. I assume the primary metrics I should be interested in are %Disk Activity and Disk Queue Length, right?
What are the actually guidelines for these metrics? Also, Are there other perf mons I should be running against the disks?
Thanks In Advance.
Ryan Hunt
Important Catalog Changes Required : Adhoc Changes Not Allowed.
Oct 1, 2007
I require to update sysxlogins table to include one more column into it in SQL 2000 sp4.
I am trying to develop a wrapper UI over sql security so that logins can created and modified right from my UI.
Doing this is very crucial for my current project.
Kindly help. Any help would be much appreciated.
Currently i have tried: sp_configure "allow updates", 1
reconfigure with override
I also tried giving -m switch in sql service parameters and restrating the service
but nothing works....
What is DAC. I am using queryanalyzer how can i use sqlcmd -a. ? cuz i am familiar with query analyzer only .Is that necessary to do as well ??
Important - INSTALLATION ISSUE RESOLVED [read All]
Nov 14, 2005Some of you may have read my thread a while back complaining about SQL Server 2005 not being able to install with some errors about assemblies installing due to admin rights or some other type of error.
View 2 Replies View Related