SQL Server

Page 2932




  • Topics
    Replies
    Last post
  • Delete Textfiles after dataload
    by sureshv
    5 Replies
    Last post by Phil Brammer
      • I am transferring data from text file to sql server.I have created .dtsx packages. After the package executes i need to remove the data from the text file or even remove the text files. But i want my package to run it receives new textfile.What do i need to do Please help
  • Multiple Min/Max Values?
    by Mark223344
    3 Replies
    Last post by Manivannan.D.Sekaran
      • is this possiable SELECT (SELECT TOP 1 Max(Value) , convert(varchar, DateTime, 108) FROM History WHERE TagName = 'MyTag1' AND DateTime dateadd(day,-1,getdate()) ORDER BY Value Desc (SELECT TOP 1 Min(Value), convert(varchar, DateTime, 108) FROM History WHERE TagName = 'MyTag1' AND DateTime > dateadd(day,-1,getdate()) ORDER BY Value Asc) (SELECT TOP 1 Max(Value) , convert(varchar,
  • flat file source for SSIS Package don't have column in destination table: How to add?
    by Madhukar
    3 Replies
    Last post by Madhukar
      • Hi all, I am passing flat file source as a variable to Dtexec Utility. (like \package.variables[User::varFileName].Value;"D:\sourcedata.txt). Destination table is having one more column. I want to add custom value in that column at run time by parameter to Dtexec(User::varDate) I dont know how to do it, please help me. Madhukar
  • Linked server SQL 2005 to 2000
    by kshatriya
    1 Replies
    Last post by Arnie Rowland
      • I have database in 2000 which needs to be access from SQL 2005 via linked server and vice - versa How do we do that we run select statement we get following error message. Error 4064 : cannot open user defulat database : login failed. We are using SQL 2000/sp4 SQL 2005/sp2 Please advice. Thank you
  • Datetime format regardless regional settings
    by fasttrack
    6 Replies
    Last post by fasttrack
      • Hi, in tsql there is a common format for datetime (regardless regional settings) I use : 'mm/dd/yyyy' to access cols in database, but someone says that the right one is: yyyy-mm-dd. Any suggestion about that Thank a lot
  • Connection between Principal and Mirror servers
    by Hans1982
    1 Replies
    Last post by Satya SKJ
      • Hi guys, right now I am facing this scenario several times and I wonder why it can be happen. Both SQL servers are in Enterprise SP1 edition. The mirroring setup can be work fine to me. Once my principal get attacking by DDOS, then mirroring session change the status to 'DISCONNECTED' . However, after DDOS attack solved and line connection gets back on the principal server, the mirroring session s
  • Using expressions with FlatFile connections?
    by mike.groh
    7 Replies
    Last post by mike.groh
      • This seems so obvious, but is causing me a lot of trouble: The flat files input to my SSIS packages may contain an empty line between each row of data, or may be "continuous" without any extra empty lines. Here are small examples of the data I'm working with: With the extra line: "M","SFH","Single Family Mortgage Loans","Single Fam Mtg" &q
  • Server 2005 update question
    by Hemanshu
    2 Replies
    Last post by Hemanshu
      • Hi I have a C# scheduled job trying to update a whole SQL table daily . The way i can think of is drop the table everyday and create it again I cant figure out how to use the update statement Can some one help me with the update statement
  • UDF issue, just need a bit of clarity
    by drmcl
    2 Replies
    Last post by asiaindian
      • Given this simple sproc:- Create proc spGetData as select 1 as PrettyDeterministicMeThinks you cannot do this: create function fnGetData() returns @table table (col1 varchar(10)) as begin insert into @table exec spGetData --This is my function_body return end --you get an "Invalid use of side-effecting or time-dependent operator in 'INSERT EXEC' within a function" error but
  • How to install the 64 bit version of SQL Server 2005
    by Vito38947
    3 Replies
    Last post by Arnie Rowland
      • I have Windows Vista Ultimate 64 installed on my computer, along with IIS 7 and the required IIS 6 components for SQL Server 2005. I also have Visual Studio 2005 Pro installed, but I have uninstalled SQL Server 2005 Express. When I try to install SQL Server 2005 Pro, with all features, the 32 bit version always wants to install. I can't find a way to get the x64 version of SQL Server to ins
  • XML data read help
    by techy04
    10 Replies
    Last post by Phil Brammer
      • I am having issues in figuring out how to read part of an XML file and I'm not sure if it can be done. Any and all help would be appreciated. I have a file resembled this way: <btb-root xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " btb-num-trans="2" btb-date="2006-11-09" btb-time="22:40:03" btb-sender="TTT" btb-receip
  • Replication Tables page in BOL doesn't refer to MSMERGE_ARTICLEHISTORY
    by JR-J
    1 Replies
    Last post by Buck Woody - MSFT
      • Hi, Not sure if I should post this here or at connect but I noticed that ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/5696ee73-5d7c-4f26-b7ee-6831c9c3edf7.htm doesn't include MSMERGE_ARTICLEHISTORY but that this table is referenced here in BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rpldata9/html/7d4c67e4-d683-4ba5-81bd-e6ce4f7489bf.htm Also if anyone is looking at doing anythi
  • Connection is busy with results for another command
    by pwomack
    4 Replies
    Last post by Jens K. Suessmeyer
      • We are migrating our databases from MS Access to SQL Server 2005 and using the SQL Native Client ODBC driver. We also use a reporting tool called Actuate. Some of our Actuate reports use multiple datastreams to build the report. When I run an Actuate report having multiple datastreams I get the following error message from SQL Server: Error generated by the connected data source. Connection is bu
  • Upside down text
    by dchurch24
    4 Replies
    Last post by Mike Schetterer -- MSFT
      • Is there a way to print text upside down on a report
  • SQL interface data security
    by acondios
    4 Replies
    Last post by Laurentiu Cristofor
      • I would like to initiate a discussion regarding a client-side interface using a SQL db. Specifically, I want to have all users with read-only privileges, but include an event on a form that will nevertheless update a record on the server using a different user identity in ADO code - one that has read-write privileges in the database. Is this a common approach
  • SQL - Get Value Based on Average of last 30 days!
    by PedroCGD
    22 Replies
    Last post by PedroCGD
      • Dear Friends, I have a problem in SSAS to calculate a field, but probably I can resolve in with SQL statment in spite of spend time thinking in a SSAS option. So, the problem is that I have values to save for each day depending from a hierarchy... Check the images in the link: http://pedrocgd.blogspot.com/2007/07/ssas-temporary-for-msdn-forum.html In my database I have 4 tables
  • Cannot access any tables in queries
    by Christie Myburgh
    8 Replies
    Last post by Christie Myburgh
      • I am using SQL2005 (Installed on VISTA). It was running smoothly until today....for some reason I cannot access any tables in queries that I try to run in Management Studio. I can open the tables and see the information, but all queries I try to run result in the following error: Msg 208, Level 16, State 1, Line 1 Invalid object name 'DBO.BEYLEVEL16'. I tried to run simple select
  • Can't do WHERE statement with OR
    by AliRaz
    4 Replies
    Last post by AliRaz
      • I wanted to make a query to run on about 20 servers that'll give me all of the databases in that server. I wanted to hide the master, msdb, tempdb, and model databases. It works perfectly if I leave it as WHERE name != 'master' but it doesn't work if I put WHERE name != 'master' or 'msdb'. I get this error: Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near 'msdb'.
  • Is there a limit on the time Replication can be down?
    by SillyMS
    3 Replies
    Last post by Martin_McNally
      • I was asked if there was a limit on the amount of clock time that the Replication agents may be down without snapshotting the subscribers. I think that the only factor is if the MSDB database contains the necessary data to feed a restarted Replication Agent. Any comments
  • Checking a Column Data Type
    by EcoAndrew
    5 Replies
    Last post by Sami Samir
      • Here is the issue, I was given the task of creating a datamart by combining the information from several different database servers. While doing this I ran into an interesting issue that I can't seem to figure out. I have two tables, one table has a code value in it pointing to the corresponding lookup table. The lookup table for whatever reason (I didn't build the application or the dat
  • VBA + TSQL - GO Problem passing SQL script trought VBA Excel
    by ajliaks
    8 Replies
    Last post by ajliaks
      • Hi, I am not sure where to post this question, because is related to both TSQL & VBA Excel. I am working under SQL SERVER 2000, and I have a query as described below: Code Snippet USE mydb SELECT Block ... GO ALTER TABLE Block... GO UPDATE Block... SELECT Block... If I writte the query as shown above directly in SQL SERVER, it does work.
  • deploying SSIS
    by Paarul
    2 Replies
    Last post by Rafael Salas
      • Hi We are storing our packages in File System. Process: BIDS->Right Click on soln file ->properties->Deployment Utility->DeploymentOutputPath--Bin\Deployment So it creates a folder with the project name and all the packages in C:\Program Files\Microsoft SQL Server\90\DTS\Packages\Project While executing the package on Server what should be thesource of the Package I mean
  • How can I be convinced by what the model says in particular for Time series?
    by Helen999888
    2 Replies
    Last post by Helen999888
      • Hi, all here, I want to hear from you for your experiences on how can we be convinced by what the model predicts particularly for Time Series algorithm As we are not able to see the model accuracy chart for that, in this case, how can use the model results E.g. we wanna know the possible sales amount of next month for a particular store in order to buy in the goods, in this case, how can we mak
  • Pull subscriptions mantenance with web synchronization
    by Genied
    0 Replies
    Last post by Genied
      • Hi all, I have a problem with merge replica over web using anonymous subscriptions: - How to remove a subscription on the publication server: after calling the Remove() method on a MergePullSubscription object I should call the RemovePullSubscription on the MergePublication object but it requires a ConnectionContext to the publisher, since I can't reach the server directly what
  • Passing parameters to LookUps
    by -HLL-
    7 Replies
    Last post by MatthewRoche
      • I am trying to make a SSIS package.. In the dataflow of my package, I must check from one table whether a row exists, and if that row exists, I should get some other row from another table, and update that.. I think to check whether a row exists, i should use "Look Up" But cant we pass parameters to LookUP I am trying to use this SQL: SELECT count(*) FROM