1
  • Supression by date and field data

    I am trying to suppress a text field within a section by both field parameters being null and also by specific time frame. The formulas work independently just fine, but not when placed together. (isnull({DBA.POST})= false or isnull ({DBA.ANNUAL}) = false) and {DBA_DATE.Report_DATE} < DateTime...

    KMarie15 pointsBadges:
  • SQL SERVER

    The SQL Server mobile edition is supported on?

    siphesihle10 pointsBadges:
  • Internet Connection Battle in windows 2003 Server.

    My customer currently is using a Windows 2003 server with 2005 SQL server, and an active directory in place. The server is set to do DHCP and DNS on the LAN. We have a Cbeyond Cisco Fiber router recently installed. All workstations are set to Static IP address same Sub net with Default Gateway...

    greatjubee165 pointsBadges:
  • Run time error 3265 VB6.0/SQL2005

    I am making a report inwhich i want to insert some values from a diffrent Table ( By making a module) Coding of Module is:- Public Function Deposit(ByVal M) Set conn14 = New Connection Set rs14 = New Recordset With conn14 .ConnectionString = Connection = "provider=SQLOLEDB.1;Integrated...

    DEEPSOFT40 pointsBadges:
  • Connecting to SQL Database

    We are no longer able to connect to our SQL database or open the DB manager on Windows Server 2008. This is SQL 2005 how can we troubleshoot this issue? We have a 2.9gb database and backups from each night.

    NewnanIT1,110 pointsBadges:
  • Optimize SQL 2005 databases on a schedule

    How can I optimize my SQL 2005 databases on a schedule?

    NewnanIT1,110 pointsBadges:
  • Adding another level of security to SQL 2005 database

    We have a SQL 2005 Database. It is protected by Windows Authentication. Can we add another level of security - requiring a SQL username and password along with a valid user name and password on the domain?

    NewnanIT1,110 pointsBadges:
  • Alter proc to fetch a table structure from SQL Server 2005 database

    hi please segest me... what is the problem in this proc. CREATE Procedure sp_tab @tablename nvarchar(517), @flags int = 0, @orderby nvarchar(10) = null, @flags2 int = 0 As if @flags is null select @flags = 0 if (@tablename = N'?') begin print N'' print N'Usage: sp_table_struct @tablename, @flags...

    Amitshukla60 pointsBadges:
  • T-SQL Programming Tutorials

    I am looking for a website that is free and where I can learn to write better T-SQL views and stored procedures.  Also, would like to find some good books to learn more about managing a SQL 2005 database.

    Luby10 pointsBadges:
  • Extracting in SQL Server 2005

    IS THERE ANY WAY TO EXTRACT FROM A FIED EXAMPLE: I HAVE A ADDRESS LINE AS 1065 VALLEY LANE APT 120                                                       SCHAUMBURG...

    Hydrostani20 pointsBadges:
  • Web Hosting strategy – NAT’ing and ARR

    I'm looking to develop a new strategy for our web hosting farm. Currently I've got  set of standalone IIS 6 web servers and sql 2005 database servers sitting in a network behind a kerio winroute proxy (which handles our nat'ing and intrusion prevention and VPN to our office location) which in turn...

    Phil4mat5 pointsBadges:
  • SQL Server 2005 Performance

    1. How can I lookup the change rate of a database? 2. How can I check the percentage of calls to the database that are reads? 3. How can I check the percentage of calls to the database that are writes?

    Rick Martinez585 pointsBadges:
  • SQL-Using count and inner join in a single query

    Hi Trying to retrive a report from the DataBase using left join on two tables. To get the count of resultant table, I'm using count. But the output shows error. If I comment count statement then the query executes successfully. I feel there is some error in the syntax of the count that I'm using....

    SQLmurali5 pointsBadges:
  • Migrating from Microsoft applications to Oracle

    How can I easily convert my SQL 2005 databases to Oracle's latest iteration? We are moving away from Microsoft applications and want to migrate to Oracle. What do I need to do to prepare?

    ITKE345,175 pointsBadges:
  • Changing over to DR database from SQL 2005

    I have set up log shipping from my production SQL2005 databases to my DR server and all seems to be working fine. On examing my DR databases they are all in (Restoring...) mode.  How do I now access my DR databases if/when my production system goes down?  There does not seem to be any obvious...

    Swales1015 pointsBadges:
  • SQL 2005 Database Compare

    If there a way to compare two similar database to find where a Stored Procedure is different between the second database. Different in it not there or the Create Date or Modify Date is different?

    SQLNovice15 pointsBadges:
  • Auto backup configuration in SQL2005

    How to setup an autobackup for the backup type of Full database and transaction log together as a single bakup file in sql2005.? We can setup to backup full database seperately and transaction log seperately, but i wanted these two should be a single backup file. Any suggestion pls.

    Shamoh40 pointsBadges:
  • Can I add a local SQL 2005 instance to a clustered node

    I have a 2 nodes (Active/Active) SQL 2005 Standard cluster. Since SQL STD only support two clustered instances, can I add a local instance to each node? I don't need this local instance to fail over. Is it possible to have the two clustered instances an two local instance one on each node?

    NetWeb70 pointsBadges:
  • Reporting and Mirrored SQL2005 DB

    Can i access the sql2005 mirrored db via crystal reports for reporting

    Civmailman15 pointsBadges:
  • indexes on a large table

    hello, i got a 5milion rows on a single table, my database is sql2005 and my select is : SELECT top * FROM tbl1 WHERE ip_from <= 3515134258 and ip_to >= 3515134258 the 3515134258 is on a sample but the format is similar: SELECT top 1 * FROM tbl1 WHERE ip_from <= [value] and ip_to >=...

    Bbbttt15 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following