SQL Server

Page 1986




  • Topics
    Replies
    Last post
  • Server: Msg 3136 Restore Differential Database Backup Fail
    by lingling
    7 Replies
    Last post by Deepak Rangarajan
      • I have done a full backup on 3pm, and a differential backup on everyday 5pm. I try to restore it back in my testing server and i encounter the problem in restoring the File3 and i try to restore the File 2 and it is okie. Can i know wat is the problem usually cause this error Thank you File 1: Full Backup File 2: Differential Backup File 3: Differential Backup
  • Remote SQL server access
    by Sam Williamson
    2 Replies
    Last post by Sam Williamson
      • I'm writing a piece of software that is designed to access data from SQL server. The office's server has SQL server version 7 installed. The software works perfectly when running on a computer on the network in the office. I however am trying to work out how to use use the software from my home computer and connect to the SQL server database remotely. I've never done this before and I'm finding it
  • Using sp_trace_create (SQL Server 2005)
    by KenEric
    1 Replies
    Last post by Ben Aminnia
      • I have been given the task in using T-Sql procedures. The objective is to create audit logs usibg the sp_trace_create procedure. Can you provide some guidance in where can I find some sample coding using the above subject command Please note that I'm using SQL Server 2005
  • Generating and Printing Reports
    by ifaber
    14 Replies
    Last post by Jamie Thomson
      • I've created a data flow where I have linked to an OLE DB Source then created a Flat File Destination. My file is now on my c: drive. I'd like to use that data to create a report, then print to a PDF. How would I do that Currently I was doing this in Access, but I am moving my processes to SSIS.
  • Easy way to reference the next/previous row?
    by Paul Over
    6 Replies
    Last post by Paul Over
      • Good morning, I'm trying to use an existing SQL table to calculate the labour value of products being manufactured. I was hoping to use a CASE statement with the logic; If the part number of the next row is equal to the part number of current row and the operation number of the next row is greater that the operation number of the current row then take the labour value of this row
  • File System Task - output file variable syntax????
    by kblackwell
    13 Replies
    Last post by Jamie Thomson
      • Hi This should be incredibly simple and easy, but I can't find any examples of how to do this. I just want to make a File System Task move a file, and have the destination be filename + date and time. For example \\server\share\filename02072007.txt What syntax do I use in a variable to make this work Thanks
  • 2005 Transactional Replication Performance Problems - help please
    by ColSchmoll
    14 Replies
    Last post by Michael Hotek
      • I have just upgraded from 2000 to 2005 and my transactional replication is running very slow, I already have a latency of 10 mins and its getting worse. I'm just using the default agent profile, is there anything I need to change Help please.
  • SQL statement question again......
    by pinoyz
    3 Replies
    Last post by oj
      • Hi, Can someone help me regarding this SQL statement, how can we make a new column for example Table name tel ian 111111 222222 shane 3333333 4444444 or ian 111111 ian 222222 shane 3333333 shane 4444444 and the new output is this one name tel1 tel2 ian 1111
  • Help: trouble dropping master key
    by DevGal
    1 Replies
    Last post by DevGal
      • It could be trivial question. I have trouble dropping master key. when i execute the following query.. open master key decryption by password = 'pass1234$' alter master key drop encryption by password = 'pass1234$' close master key drop master key go I get the following result.. Msg 15558, Level 16, State 1, Line 3 Cannot drop enc
  • Access Issue in in 2005
    by bes7252
    2 Replies
    Last post by bes7252
      • I have some software that connects to SQL Server using Integrated Security in my connection string. My users are members of an active directory group. In SQL Server 2005, I've added the AD group to Logins, checked the User Mapping for the database, and checked role memberships db_datareader, db_datawriter and public. When I look at Properties->Permissions of the database, the AD group is
  • Invalid character value for cast specification
    by sadie519590
    12 Replies
    Last post by Maurice Maglalang
      • I have a Data Flow task that is simply copying data from table A to table B. (there is a derived column in between however) All the columns in table A are varchar(255). The columns in table B vary: floats, decimals, etc However, I am getting a bazillion errors when I run this, each of them to the effect that: Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurre
  • Searching for Nulls
    by Duncan McC
    2 Replies
    Last post by Duncan McC
      • I have two number columns and i need to find the SQL code to search for nulls in both columns and return them.  I also need to return all other columns in the table aswell. I have tried simething like this:- SELECT * from Table WHERE Column one is null UNION SELECT * FROM Table WHERE   Column Two is null Unfortunatey this brings back the full table l
  • Turning off "Select All" in SP2
    by csi_hugh
    7 Replies
    Last post by givemeabreak
      • Does anyone know if there is an easy way to turn off the "Select All" option from appearing on reports with multi-selects I am going to have a hard time getting the development staff to update all of our reports AGAIN after making them conform to SP1. Please let me know if there is a way before I install SP2. Thanks.
  • Large database growth out of control
    by DaMack
    14 Replies
    Last post by Arnie Rowland
      • Hopefully I'm posting in the right area. There is a database that has grown to about 41-42 GB in size in about a 2 month period. The previous database had grown to about 22 GB before it was purged out. I'm running this on SQL 2000, and I've tried running all the DBCC SHINKFILE and SHRINKDATABASE commands to no avail. In this case, the MDF file is the one that has grown out of control as opposed to
  • SQL Server Config Mgr - errors, doesn't open
    by Mike Br
    4 Replies
    Last post by Vidhya Sagar
      • When clicking to open SQL SERVER CONFIGURATION MGR I recieve the following.... MMC cannot open the file C:\Windows\System32\SQLServerManager.msc This may be because the file does not exist, (it does) is not an MMC console, or was created by a later version of MMC This may also be because you do not have sufficient access rights to the file. I am stumped. This wo
  • SqlCe database corruption
    by Qiuwei
    3 Replies
    Last post by ErikEJ
      • Hi; there; I know that power failure can corrupt a sdf file ( http://support.microsoft.com/kb/296076/en-us ) Apart from that, is there any other reason can corrupt a SqlCe2.0 sdf database Another problem I found in my sdf database is corrupted record. There is a record in the database has all field with "null" value. When I tried to compact this database in "Query
  • dimension security doesn't work when you use {}
    by furmangg
    2 Replies
    Last post by furmangg
      • I think this is a bug, but I want to check that I've understood the expected behavior before reporting it. 1. Build a Geography dimension where the key attribute is City. Also add a State attribute. 2. Define dimension security for the Geography.City attribute and make the allowed set {Geography.City.Dallas} 3. When I run an MDX query with Geography.City.Members it returns only Dalla
  • What data type to use for this different things
    by Truedsson
    1 Replies
    Last post by Arnie Rowland
      • Hello. I am a newbe in this and I tried to find the information on the msdn but could not find a god answer. I am using VisualStudio Express 2005 and a SQL Server Express version. In a Visual Basic application I use "radio buttons", "tick boxes", "Combo Boxes" and "Numeric Up Down". But I cant figure out what data type to use to save the data in a SQL server
  • Insert to multiple table
    by stein80
    2 Replies
    Last post by stein80
      • I want to insert 2 table at the same time . There are relationship between them .My tables are: Topic : topicId, topicDate,topicInformation Reply: replyId,topicId, replyInformation
  • recursive calculation with cte
    by steve1024
    5 Replies
    Last post by steve1024
      • Helo, Given the following dataset: org dataset ------- product inbound diff outbound date A 10 20 NULL 200701 A NULL -10 NULL 200702 A NULL 30 NULL 200703 B 100 40 NULL 200701 B NULL -20 NULL 200702 B NULL 60 NULL 200703 ... I want to calculate the outbound column and iterate t
  • Events keep bubbling up, even with Propagate=False
    by Dirk DC
    14 Replies
    Last post by jaegd
      • I've been pulling my hair out for the last couple of weeks trying to make my SSIS package more robust. I'm running SQL 05 SP1 on Windows XP SP2. Right now when there's a failure, the error propagates all the way up and my package stops running. Clearly not very robust. I have a heartbeat portion that makes a connection to the database every couple of minutes. Sometimes it loses the connection in t
  • Database capacity
    by Sheikh Mohammed
    2 Replies
    Last post by Sheikh Mohammed
      • Hi, I¡¯m working in a DWH project the source system have data from passed 30 years and the total number of records from the source system is 10 million. I¡¯m need to do the estimation for the data base for the up coming 10 years of data. As I can predict that the 30 year of data is 10 million then expected data for 10 years would not be more then 3 million. The ETL tool I¡¯
  • Numbering an ordered set
    by JohnSLG
    14 Replies
    Last post by Darren Gosbell
      • I created an ordered set in my cube. Is it possible to number the result set from one to whatever I'd like to query the cube and see 'result' 1 'result' 2 'result' 3 'result' 4 'result' 5 I'm querry through Reporting Services and I could probably figure out a way to have SSRS number the set. But I'm going to have different sets in different orders and would rather have S
  • Cannot connect using ADO with Excel Microsoft Jet Provider 4.0
    by dez66
    1 Replies
    Last post by Dan_Comet
      • Hi: I have a vb 6 app that exports data from sql to excel. The user has the ability to select either local or server. When they select server, the connection string is modified to include the server name instead of the local msde instance to look like this: "provider=sqloledb;data source=MyServer;initial catalog=MyDatabase;user id=UserX;password=PasswordX;database=MyDatabase" I'
  • Writing txt file into SQL table
    by Downforce
    14 Replies
    Last post by Downforce
      • Hi, My situation is: For example i have txt file called serverlog.txt txtfile contains: serverid 3 Last log on 19/3/2007 Linkstatus OK I have a table created with the following values Table: serverlog serverid(primarykey) LastLogOn LinkStatus So my question is how do i get my txt file variables into the sql table. Is there no impor