SQL Server

Page 6056




  • Topics
    Replies
    Last post
  • Search for blank Columns
    by Skola17
    6 Replies
    Last post by Manivannan.D.Sekaran
      • Hi , If asked to find all the columns across tables which contains any NULL or blank value then what could be the best approach I am sure there must be a way other than checking each column of each table . Can anyone help me out in this . Cheers
  • Sql server reporting Services error The underlying connection was closed
    by Bluetongue
    1 Replies
    Last post by Bluetongue
      • Hi, We have a mature instance of SQL Server 2000 reporting services that has stopped working for no apparent reason. When browsing to http://reportserver/reports we receive the following error Error The underlying connection was closed: Unable to connect to the remote server. Home The installation is running on three servers - 1 sql cluster (sql 2000 sp4) and two IIS
  • GRANT SELECT ON [dbo].[TblAreaCatmap] TO [admin] prevent grant from being automaticly add to each column
    by thecaveman2
    9 Replies
    Last post by thecaveman2
      • GRANT SELECT ON [dbo].[TblAreaCatmap] TO [admin] prevent grant from being automaticly add to each column Is there a way when you issue a grant select to a table or a view to not also grant select for each column. The problem is when you use the grant command it automaticly adds the grant command to each column. I want to grant the permission at the table level so when the table is sc
  • Fetching Data from a web service
    by MSDN Student
    1 Replies
    Last post by Jamie Thomson
      • Hello All, I have to fetch data in an ssis package from a set of web services. what is the best way of doing this The web services are session based, this means that multiple calls are needed to complete one operation. like one to log on, second onwards to execute calls, and the last one to log out. (there is some cookie management also required to logon successf
  • The merge process was unable to create a new generation at the 'Subscriber'.
    by Pauly C
    14 Replies
    Last post by Pauly C
      • I keep getting the following error message on the merge agent on all 26 subscribers. The merge process was unable to create a new generation at the 'Subscriber'. Troubleshoot by restarting the synchronization with verbose history logging and specify an output file to which to write. The error occurs after the merge agent runs just over 31 minutes. Some messages displayed wh
  • SQL 2005 Server DDL Trigger Errors
    by Brian Laws
    12 Replies
    Last post by tvu4251
      • Greetings! I've been working on a SQL 2005 project, and have really been excited about the new DDL triggers. I managed to implement some database-level DDL triggers successfully. However, I keep getting an error when I try to create a server-level DDL trigger. For several of the event groups, I keep getting the following error: Msg 1082, Level 15, State 1, Procedure tr_Server_Audit_Security, Li
  • Is this possible without using cursors?
    by Walter Luszczyk
    14 Replies
    Last post by Waldrop
      • Hi! I have 2 tables: Person and Address Person (   PersonID int PK ) Adress (   AddresID int PK,   PersonID int FK,   Default  -- 1 if address is default for person ) so when I join those table it yelds (for example): p1  a1  1 p1  a2  0 p1  a3  0 p2  a4  1 p3  a5  0 p3  a6  0 Person may: -
  • xp_cmdshell and network share
    by kinny_k
    2 Replies
    Last post by kinny_k
      • EXEC master.dbo.xp_cmdshell 'dir r:\*.bak /OD' - this returns "The system cannot find the path specified." EXEC master.dbo.xp_cmdshell 'dir c:\*.bak /OD' - this works properly r:\ is mapped to a VM shared drive. The SQL Server service is starting with a valid domain account and the share permission are correct. Works fine from a DOS shell. What am I missing
  • How to Only Backup Principal, not mirror
    by Niels Jensen
    7 Replies
    Last post by Niels Jensen
      • I have a Server Agent Job that does a full backup of my principal database. I then have a separate job which does an incremental backup of the log files every 20 mins throughout the working day - the incremental backup sends me an email if it fails. If I establish a failover to the mirror server, the backups continually try to run, sending me an email every 20 mins telling me that it can't back up
  • Segment error when processing partition
    by Leandro Tubia
    2 Replies
    Last post by LeandroTubia
      • When processing a partition against a SQL Server 2005 database the following error appears: "Error in Storage Engine. Segment constraints have been violated" The original message in Spanish: "Errores del motor de almacenamiento OLAP: Se han infringido las restricciones impuestas en el segmento de particion." The disk has enough free space. Sp2 wit
  • Deploying problem with reports
    by shamen
    4 Replies
    Last post by shamen
      • Hi, I have two aquestions. 1. How do I select data ovewrite option in SSRS When I deploy a report i got a following error message. Warning : Cannot deploy data source mydatasource to the server because it already exists and OverwriteDataSources is not specified. 2. When I try to snapshot a report on report manager, I get a error message. "
  • Slow Performance When Rendering Pages in SQL Server 2005 Reporting Services
    by Mike @ DanRic
    3 Replies
    Last post by Mike @ DanRic
      • I have designed a fairly simple report in report designer that uses an analysis services cube as its input, and a basic matrix object as the primary design component. Cube performance either via object browser in Analysis Services or via connection from Excel is great. It does exactly what you build a cube for, i.e. it builds aggregations you can get to quickly. However rendering from a report des
  • Verfiying stored procedures
    by EwenTweedie
    7 Replies
    Last post by EwenTweedie
      • Hi, I wish to run a stored procedure which will verify a digital signature on some data and return a pass or fail. Is there a way for me to ensure that the stored procedure returning the result is one created by me rather than one created by someone else that always returns a pass without checking the digital signature I know i can encrypt stored procedures but these encryptions can be br
  • Report Builder problem
    by Luis Esteban Valencia Mu&a
    0 Replies
    Last post by Luis Esteban Valencia Mu&a
      • Hello, I got the following problem when I try to execute a report in the report builder. Los permisos otorgados al usuario 'SE\aspsys' son insuficientes para realizar esta operacion. (rsAccessDenied) Maybe its something aboout security on virtual folders of IIS I
  • Hi Greg , Any Solution for Alter tables on publisher and subscriber end as well ....?
    by adrshen
    5 Replies
    Last post by Mahesh Dudgikar
      • Hi Greg Y and seniors ones, I am working with replication on sql server 2005 (standard edition sp1).There is scenario that some time one of the team of coders want to alter objects mostly tables being replicated on publication database but unable to do that due to error on adding column "Cannot add columns to table 'table1' because it is being published for merge replication..
  • How do you handle this control flow issue, asked Mr. Newbie
    by BlackCatBone
    6 Replies
    Last post by BlackCatBone
      • Greetings, I have a question about the best method to ensure the proper flow of control within a package. I have three related SQL tasks ¨C A, B, and C ¨C that must execute in sequence. If any one of the tasks fails then the remaining tasks should not execute because each is dependent on the previous step. (A ¡°success¡± precendence constraint.) Likewise, I have a second set of SQL
  • DTExec Reporting Options
    by omegarazor
    8 Replies
    Last post by Karunakaran
      • Currently, we are running a Master Package with sub-Packages that are executed as a result. We run multiple days by executing a .bat file of DTExec commands. For Example: Code Snippet DTExec /FILE E:\ETL\FinancialDataMart\Master.dtsx /SET \Package.Variables[ReportingDate].Value;"1/02/2007" > etl_20070102.log mkdir E:\ETL\ErrorLogs\Archive\20070102 copy E:\ETL\ErrorL
  • sum formula that always adds to zero
    by peterferguson_uwo
    2 Replies
    Last post by peterferguson_uwo
      • OK, I'm new to Excel 2007 but have used excel for a long time. I have a column of numbers and I'm trying to add them up. I click Sum, I highlight to cells I want to add and hit enter and it comes up with zero. The formula looks fine =SUM(G125:G127) and there are numbers in those cells (that don't add to zero) but it keeps adding them to zero. Can someone tell me why before I put my fist through my
  • concatnate values for different rows
    by ash564711
    2 Replies
    Last post by Kent Waldrop My07
      • Hi , I have a situation where i need to concatnate values from different rows and store it a one string. sample dealid date 1 1/5/2007 1 2/4/2009 2 5/5/2004 2 8/5/2006 2 4/8/2006 so for one particular deal how many ever dates there are , i need to concatnate them all separated by a comma(,) and return and on
  • count measure question
    by pajkus
    1 Replies
    Last post by Bryan C. Smith
      • Hi, I have table with column which is containing two values ("Y" and "N") and I want to create measure which will count Y values and second measure which will count N value. How can I create it Thank you Pavel
  • SQL SP2 thru MS Update - Issue?
    by Fred564486
    13 Replies
    Last post by kennethelamb
      • Howdy All, I have SQL Express install on my PC. I utilized Microsoft Update to keep thing current. During the last update process, MS Update found SP2 for SQL and proceeded to download and install. The installation process seemingly finished properly and I received confirmation that updates had install properly. But now when I go to MS Update, the SP2 for SQL is still listed. It shows that it is d
  • Cube Process Very Slow
    by Dz0001
    5 Replies
    Last post by Thomas Ivarsson
      • One of my cube in my AS 2005 DB has about 24 million record and bunch of dimensions. I have been watching its processing time in the past week or two. I have been doing Full Process every morning, on average it takes about 23 minutes to finish the full process. However starting yesterday, all of sudden, it took 34 minutes to finish, then today, it is like crawl, it is now about 68 minutes, it is o
  • How to encrypt store in sql2005?
    by ERP1
    4 Replies
    Last post by Laurentiu Cristofor
      • I have a Store in sql 2005! I want to encrypt this how Thanks !
  • Couple of Easy Questions, newbie here
    by Coldfire
    1 Replies
    Last post by Coldfire
      • I am using Merge Replication for my scenario (POS). I have made the publication (articles are a set of tables in DB ABC) and its subscription (in same DB and diff tables xyz1, xyz2). I have scheduled the push subscription as run continuously between Dates(e.g current date to 3 days ahead, just for testing). Now, Can I change this schedule How can I edit/remove the artilce from the above publicatio
  • SQL DTS Package.
    by Tarana
    9 Replies
    Last post by Jamie Thomson
      • I have a SQL DTS package, with 3 steps..The way I have set it up is , if On success of step A, exectue task 1.. And On failure of step, A, Execute task 2. I also have an automated email that I receive, if this SQL job fails. What is happening, is if the step fails, it proceeeds correctly, with step 2 and does what it is suppsoed it.. BUT i still get the page daily, that the job is failed. Because