SQL Server

Page 4789




  • Topics
    Replies
    Last post
  • Can I/Should I turn off logging on some tempdb transactions?
    by DavidR100
    6 Replies
    Last post by Arnie Rowland
      • I am doing some tempdb work for reporting only, and the trans log is getting to 5GB and I dont really see why I need rollback. If it fails I can just tell the user and the #temp tables will be deleted when the SP returns anyway. So, can I tell SQL Server not to bother with the transaction logging on these tempdb inserts/updates. Have to admit something feels a bit iffy about d
  • Released CozyRoc SSIS+ 1.1 Beta 3
    by DearDearDear
    2 Replies
    Last post by DearDearDear
      • Released a new beta of SSIS+ 1.1 library. It includes a new SSIS Zip Control Flow Task for compression and decompression of Zip, GZip, BZip2, Unix, Tar archives.
  • OLAP, DTS and SQL
    by Mikela
    9 Replies
    Last post by Mikela
      • Hello, I have some dimensions and I want to automate them to be launched every week (for exemple). How can I do it I have no idea,l and don't know where to start looking for in google... Should I do a stored procedure to launch a dts, that launch them And then program a job to be launched weekly Is there any way from the Visual Studio 2005 to schedule the dimensions and cubs Any h
  • sp_ListFiles works differently based on the O/S level.
    by SillyMS
    0 Replies
    Last post by SillyMS
      • Be sure to test "sp_ListFiles" carefully if you use it. It will fail on some versions of Windows because "DIR" returns different time formats. For example, Windows NT 5.2 (3790) does not return the required time format. "usp_Clean_Backup_Files" uses "sp_ListFiles" and that is how I came across this.
  • rda dropping primary key index
    by donjek
    13 Replies
    Last post by donjek
      • I am using RDA to download a tables I use TrackingOffWithIndexes the issue is that when I download a small set of data the primary key index is there when I download a larger set. the index gets dropped (no error) just slowness when querying the table the max database size is set to 1024mb and the temp database size is set to 1024mb the actual db size (with the missing i
  • report
    by jovica-kar
    1 Replies
    Last post by Andrew - T4G
      • i need example of report, for some busines solution, do you know where i can to find it.
  • counting all records in a database
    by Gess Man
    2 Replies
    Last post by GlennAlanBerry
      • Is there an easy way to count all records in a database
  • copy index statistics from production to development.
    by TheBrick
    3 Replies
    Last post by Umachandar Jayachandran - MS
      • I have a very large database that I need to be able to copy the statistics only from the production database server to my develoment environment. I need to be able to reproduce the execution plans on development without moving all the data. MS does this when they need to review the exeecution plan for large complex databases. Need help.
  • An attempt to attach an auto-named database ....\aspnetdb.mdf failed
    by mfauziii
    14 Replies
    Last post by mp5k
      • I've installed VWD 2005(Beta 2) and MS SQL Express and also followed the aspnet tour at http://beta.asp.net/guidedtour2 . After trying new webcontrol (login control) and trying to execute the page, I've got an error such as below: An attempt to attach an auto-named database for file c:\inetpub\wwwroot\Demo\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file can
  • Database in recovery
    by windthorstking
    3 Replies
    Last post by NiC_72
      • I have a database currently showing to be in recovery. I have not been able to find a GUI method to monitor the progress (to determine when it might complete) so is there a command line T-SQL method to monitor the recovery process
  • SQL Server Replication License Requirments
    by Matt552989
    1 Replies
    Last post by Tarek Ghazali
      • I'm setting up SQL Server 2005 Replication. I have purchase a processor license for SQL Server 2005. Do I need a Windows CAL for each device that will be accessing the replication via IIS Thanks! Matt
  • how to enable a user account
    by stswordman
    3 Replies
    Last post by stswordman
      • I found the the status of guest account in model database is abnormal,but i don't know how to make it active. any suggestions thanks
  • Why can't I use columns based on case down in my where clause
    by Thomas Koelle
    1 Replies
    Last post by Kent Waldrop Se07
      • I am writing a fairly simple sql, and I would like to write something like Code Snippet select firstname as firstname, case when firstname = 'Peter' then 'yes' else 'no' end as whatever from MyTable where whatever = 'yes' And this should then select out the rows where column number 2 is 'yes'. It doesn't w
  • The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. (System.Data)
    by Nanotasher
    5 Replies
    Last post by RonggangYu
      • I am on an XP Pro 32-bit laptop, running SQL Server 2005 Developer Edition. I want to import an Excel spreadsheet into one of my databases using (formerly known as) DTS. The Excel spreadsheet was created in 2003 (I have Office 2007 installed on this laptop). Whenever I try and do any OleDb import, I get the error: TITLE: SQL Server Import and Export Wizard ------------------------------
  • Service accounts, local admin, and sysadmin question!
    by sadie519590
    5 Replies
    Last post by sadie
      • Hi, Re: SQL Server 2005 We have defined a local administrator to be the SQL Server and SQL Server Agent services user, and is also the job step owner for some SSIS packages I am running. My question is, isn't by default a local administrator ALSO granted sysadmin in SQL Server According to this link, it seems to imply this: http://msdn2.microsoft.com/en-us/library/ms143
  • Incorrect Totals
    by _Mark_99_
    6 Replies
    Last post by _Mark_99_
      • Here's my cube structure in a nutshell. I've got a measure group called MG1 which contains measure "Units". I've got another measure group called MG2 which contains measure "Price". I want to add a new measure called "Value" that should correspond to Units * Price. I'm trying to use MDX script to do this calculation: [Measures].[Value] = [Measur
  • Error: Subreport could not be shown.
    by Eric Hausig
    12 Replies
    Last post by joslat
      • I work for a Microsoft Gold Partner and I am having a problem with subreports in SSRS 2005 SP1. Essentially, I have a report that contains subreports. The main report has a table that passes a parameter to a subreport in each row. The report renders properly when I preview it in Visual Studio, but once deployed to the server it only renders the first subreport for the first row, and every subre
  • Converting XML Datetime to SQL Datetime
    by Gary8877
    11 Replies
    Last post by Gary8877
      • I have an XML colmn in SQL 2005 table which looks like: <abc> <abcdate>2007-01-31T13:47:27.25-05:00</abcdate> </abc> The following query : SELECT xmlColumn . value ( '(/abc/abcDate)[1]' , 'nvarchar(30)' ) FROM abcTABLE Returns 2007-01-31T13:47:27.25-05:00 --------- SELECT CAST(xmlColumn . value ( '(/abc/abcDate)[1]' , 'nvarchar(30)' ) AS DATETIME
  • how to get YYYYMMDD formate
    by sqldba2007
    12 Replies
    Last post by sqldba2007
      • Hello, I use CAST ( PYBTHC as varchar ( 2 ))+ CAST ( PYBTHY as varchar ( 2 ))+ CAST ( PYBTHM as varchar ( 2 ))+ CAST ( PYBTHD as varchar ( 2 )) to get a string like 199232. How to get 19920302 What function I can use to pad '0' left when it less than 10> Thanks
  • Comparison of SQL Server Reporting Services to Access Reports, Crystal Reports, Cognos or other options
    by Hal1490
    3 Replies
    Last post by Hal1490
      • Hello SQL Server Experts, Data Analysts, and Report Writers et al: re: Reporting Options with SQL Server I wanted to propose an offshoot to the pryor thread: Would anyone take a stab at comparing Access Reports, Crystal Reports, Cognos or other options to all the Reporting Services and its components offered as part of SQL Server , especially as to extracting data from SQL Server into a report fo
  • Changing the default database files path fails
    by
    5 Replies
    Last post by Waleed Yaseen
      • i have the following code segment which works fine as is: try { ServerConnection connection = new ServerConnection ( "localhost" ); Server server = new Server (connection); if (!server.Databases.Contains( "SMO_TEST" )) { Database database = new Database (server, "SMO_TEST" ); //FileGroup fileGroup = new FileGroup(da
  • SSRS in Sharepoint, WrapperReportRenderingException/JobCanceledException for large Matrix (OLAP) reports
    by Purple Frog
    5 Replies
    Last post by Purple Frog
      • Hi all - please help! I'm running SSRS 2005 (9.00.3027.00) in Sharepoint integrated mode on a Win2003 SP1 box. This works fine for most reports, including matrix reports sourcing data from SSAS 2005. However, I have a couple of large matrix reports (7 columns per group, 12 column groups, 150 rows, 1 row per group, data from SSAS) that run fine when I run them in VS2005, but as soon as I try
  • AMO:Can any one knows hoe to rename a role and permissions to that role
    by vishweshwar
    2 Replies
    Last post by vishweshwar
      • Hi All, I am working on AMO and vb.net.Here with this I am managing Analysis Server 2005 with AMO. My problem is , am able to create a role with role members . but when i try to rename a existing role i couldnt see any direct methods available with AMO.So what i did is first i created a role with normal procedure and then after , i am planning to drop the existing one. here wh
  • RDA - multi table error for tracking
    by moldau04
    5 Replies
    Last post by moldau04
      • Hello, I receive an error message when I try to Push data that the table is not tracked. However, when I try to turn on the tracking option it gives me an error that the table is a multi query table and therefore cannot be tracked. Here is my code to Pull the table. string TPDAPull = string .Format( "SELECT Table1.Field1,Table1.Field2, Table1.Field3, Table1.Field4, from Table1 Le
  • What is the easy way to do this?.
    by Visio User
    6 Replies
    Last post by Chris Howarth
      • My table structure... enddt datetime(8) status varchar(20) when enddt time equal to server time. I want to change status field to expired. What is the easy way to do this . enddt status 8/22/2005 7:00:00 PM expired 9/22/2005 8:30:00 PM expired 10/30/2005 7:30:00 PM live 11/22/2005 9:30:00 PM live