SQL Server

Page 4310




  • Topics
    Replies
    Last post
  • Export problem
    by imranabdulaziz
    0 Replies
    Last post by imranabdulaziz
      • Dear all, i am new to sql server reporting services. i made one simple report consisting 50 to 60 records. but when i export it through report manager export option. export browser appear but it does not get exported. i seen event viewer. it does not show any messages related to it . what is problem please help me to identify it and resolve . thanks
  • Security issues with SQL 2005
    by Vladimir552654
    2 Replies
    Last post by Vladimir
      • Hello, I found scary topics with security treads for SQL 2005: http://blogs.msdn.com/ikovalenko/archive/2007/01/15/db-securityadmin-is-very-powerfull-and-dangerous.aspx http://blogs.msdn.com/ikovalenko/archive/2007/01/15/sql-server-2005-building-security-model-based-on-triggers.aspx Igor has mentioned, that SQL Server team replied about db_securityadmin topic than this
  • JOIN outside of WHERE clause ? ? ? ?
    by w3bm0nk
    3 Replies
    Last post by w3bm0nk
      • view 1 I have a view that is drawing from two tables. Each table contains fields representing cube coordinates. The view is filtering the results based on some simple logic (where the defference between two values in the tables are greater than x) this part works fine. view 2 notes field I want to include a note field in my view. This field will contain the contents of a note
  • workgroup upgrade
    by scottsanpedro
    4 Replies
    Last post by scottsanpedro
      • Has anyone had problems like this. I recently got SQL Server 2005 Workgroup edition. I did the normal 'read everything I could' to make sure I was getting the correct version for my business. After having to wait 4 weeks to upgrade, as we were waiting for our accounting system to be upgraded to come inline with SQL 2005, I came across the problem where DTS is not really compatible to the degree I
  • service broker mirror database
    by paulixml
    4 Replies
    Last post by paulixml
      • Hi I tried to setup service broker to fail over to a mirror database. After the target database failed over, the message I send stays in sys.transmission_queue with no error in transmission_status. I check the mirror server log and I see the following. An exception occurred while enqueueing a message in the target queue. Error: 15581, State: 3. Please create a master key in the database or o
  • Unable to install sql server express after removing the previous installation
    by ycxiu
    4 Replies
    Last post by ycxiu
      • I installed sql server express 1st time successfully. But later I found that there's no solution explorer(there's no item under file-new called Project). To reinstall, I removed all the components completely,including engine,msee,bol,sampledb. But could not install the engine again. I've downloaded the installation files several times and tried both sqlexpr32.exe and sqlexpr_adv.exe. The same erro
  • Modify existing report
    by SBurden
    2 Replies
    Last post by SBurden
      • Hello: How do I go about bringing a report down from the report server to modify it What kind of security access will I need The report is in production and it was created by someone who recently left the company. Thanks in advance for your assistenance.
  • Is it possible to send email to SQL Server 2005?
    by SouthernPost
    7 Replies
    Last post by Philippe
      • Now that SQL Mail is being phased out, is it possible to send email messages to a SQL Server instance
  • Security
    by ManfredSteyer
    4 Replies
    Last post by Darren Gosbell
      • Hi, we have a dimension-table ProjectManager containing the Name and the AD-UserName of projectmanagers. There is also a m:n-relation between this Table and the Table Projects and each Project has several costs. With this tables we created a cube. Now, I want to create a Role in this cube, that allows Project-Managers only to view the costs of their own projects. How to
  • Pulling Data into one column
    by Joe77
    2 Replies
    Last post by Joe77
      • I don't know if this is possible, but here goes; I need to pull sales data out of SQL into Access or Excel to run in a Pivot Table. I am currently doing this by querying SQL with an Access Database and then imoprting that data into Excel to pivot. It takes literally hours to refresh this pivot. I would like to create a SQL View to help speed this process along. The problem is that Debits
  • Reporting Services Footer issue and workarounds
    by Ronnie Peretz
    0 Replies
    Last post by Ronnie Peretz
      • I had to create an invoice report, where there is a stub on the buttom of the last page. I need a report footer and RS does not have it. I talked to Microsoft about it, here is the full emails between me and Microsoft. hope this helps Read from buttom to top -------------------------------- Hi Ronnie Sorry I was late in getting back to you as I was out of the office
  • disable trigger syntax?
    by o00oo00o
    5 Replies
    Last post by o00oo00o
      • Code Snippet CREATE PROCEDURE Staff_NoteGroup_insert ( @staffID AS int , @owner AS int , @subject AS varchar ( 256 ), @message AS varchar ( 512 ), @date_add AS DateTime ) AS BEGIN TRANSACTION SERIALIZABLE DECLARE @id as int SELECT @id = ( SELECT MAX ( id ) FROM Staff_NoteGroup ) + 1 IF @id IS N
  • SQLServer 2005 - SP2 - Connection Pool issues
    by indian09
    0 Replies
    Last post by indian09
      • Hi, I have recently installed SP2 for SQLServer 2005 and started to have connection pool issues. I have tried to explicitly mention the pool settings in connection string and yet pooling doesn't seem to work. I have one more box with no service packs applied and is pooling is perfect!. Has any one experienced this Thank you, Viswanath Ivatury
  • Insert statement from one table to another
    by Badpig521
    4 Replies
    Last post by Freddy Rios
      • I hope I can explain this!! I am trying to insert data from one table into another: from table "sheet1" into table "actoremployments". sheet1 is a temp table that had data imported into it from an Excel doc. Here is what I used INSERT ACTOREMPLOYMENTS ( EmployerCity , EmployerZip , EmployerFax , EmployerPhone , EmployerEmail , Employe
  • Rename file using File System Task Editor
    by sqrrnd
    14 Replies
    Last post by Phil Brammer
      • Could someone please instruct me on how to use the File System Task Editor to rename a file I place control on control flow tab, change the operation to rename, from there I am not sure what to do.
  • Multiple versions of SQL Server 2005 - What order to install?
    by MollCons
    2 Replies
    Last post by Jeff Wilson MSFT
      • I currently have three SQL Server instances installed on my notebook. One is v8, which I believe is used by an accounting application. The other two are as follows:- SQL Server MSSMLBIZ SQL Server SQLEXPRESS The second one (SQLEXPRESS) fails to start generating the following error:- The SQL Server (SQLEXPRESS) service terminated with service-specific error 17058 (0x42A2). Ot
  • SQL Server 2005 Express doesn't work with .NET Framework 3.0
    by Rene1968
    2 Replies
    Last post by Rene1968
      • Hi, Can anybody help me with the following problem: I have Vista Ultimate installed and within Vista .NET Framework 3.0 is installed as a part of the operating system so I can't remove 3.0 Now for MS SQL Server 2005 Express I need .NET Framework 2.0 and the SQL Server 2005 doesn't work with .NET Framework 3.0 Can't install 2.0, get the message that 3.0 is already installed.
  • How do u manage the Tempdb Growth / Shrinking?
    by MKR
    3 Replies
    Last post by Arnie Rowland
      • Iam close to Production on our new SQL Server Environment. How do u typically manage Disk Space (Particularly tempdb) -Would you have a Job to run during Non Usage Hours to Shrink the Tempdb OR -Would you have the Autoshrink ON What is the best approach
  • Unexpected line break in Text box
    by Mbhatnagar
    0 Replies
    Last post by Mbhatnagar
      • I am displaying a long string in a text box. The problem is that in some places where the string contains some text in brackets E.g. "Administer_Comp_Cars_(GBL"), the text is broken and the part in the bracket is shown on the next line, like this: ******Administer_Comp_Cars_ (GBL)**************************** There is no problem in the string itself, that i have checked. A
  • Unable to install SQl Server 2005 SP2 - Unexpected error
    by AshishGupta
    14 Replies
    Last post by Peter Saddow MSFT
      • I am trying to install SQl Server 2005 SP2 but it was throwing an unexpected error when trying to install "setup support files". O/s: Windows Server 2003 SP1 Product: SQL Server 2005 Standard Edition Log file shows: +++++++++++++++++++ === Verbose logging started: 2/20/2007 16:05:42 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: F:\SQL2005sp2\hotfix.exe === MSI (c) (74:68)
  • Multiple Table names in result data set.
    by KevinBurton
    5 Replies
    Last post by Arnie Rowland
      • I have the below query. Basically it takes from a table the names of other tables. This seems to work but the result data set has tables named as Table, Table1, etc. How can I change the names of the tables in the result set Thank you. Kevin BEGIN SET NOCOUNT ON ; DECLARE @TableName VARCHAR ( 50 ) DECLARE ReasonCategory_Cursor CURSOR FOR SELECT CATEGORY FROM
  • SELECT @@IDENTITY using System.Data.SqlServerCe?
    by moflaherty
    9 Replies
    Last post by moflaherty
      • Hi! I am having a problem getting the inserted id from a table. Here is the table: /*********************** Companies **********************************/ CREATE TABLE Companies( CompanyId int IDENTITY(1,1) PRIMARY KEY, Description nvarchar(30) NOT NULL ) GO When I type SELECT @@IDENTITY in SQL Management Studio after a successful insert, it works fine. How
  • Query question
    by dan-cat
    3 Replies
    Last post by Shyam Sundar
      • Hello, I have 2 tables with a one to many relationship. Specs SpecId - int - PK SpecName - varchar(50) SpecDates SpecDateId - int - PK SpecId - int DateFrom - datetime DateTo - datetime PriceFrom - money PriceTo - money I would like to return a single row for each specid with 5 columns SpecId EarliestDate - The earliest date value (from DateFrom) in SpecDates for the appropria
  • OpenRowSet with Trusted Connection?
    by SillyMS
    3 Replies
    Last post by oj
      • The following runs fine when connected to "myserver" but executing it from a different SqlServer 2000 session does not work. It appears the User is null. Where does the User come from How do I configure this SELECT a.* FROM OPENROWSET('SQLOLEDB','Server=MyServer;Trusted_Connection=yes;', 'SELECT top 10 loanName FROM mydb.dbo.Loans ORDER BY loanAgentId') AS a Server
  • The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs.
    by BobInIndy
    2 Replies
    Last post by tjy57
      • SQL Express 2005 with one instance on a networked dedicated stand-alone window XPˇ­ We use this for custom software written in VB.net. We are not SQL expertsˇ­ Question 1) I am getting a event viewer warning that says The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs. This seems strange, since there is only one CPU on this machine. Any ideas Quest