• Experience applying SP4 to SQL 2005?

    Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I...

    CarlMarius15 pointsBadges:
  • SQL 2005 Security to access 2 databases on same server via Stored Procedure

    We are tyring to apply best security practices by only granting EXECUTE security to Stored Procedures connected to a Role and make users members of the role. However the SP needs to access data from another DB on the same server and when trying we receive "SELECT permission was denied on the...

    A00001615 pointsBadges:
  • 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:
  • Remote Connection to SQL 2005 Express running on Windows 7

    I have a Windows 7 machine running SQL 2005 Express. I am able to connect to the SQL from the local machine. However, I am not able to connect from other machines. This machine will connect to a SQL 2005 running on Windows XP but the Windows XP will not connect to the Windows 7 SQL. I have ensured...

    Goofy90 pointsBadges:
  • 2003 Sever Domain Issue

    Currently my customers running a Windows 2003 server with 2005 SQL and a Active Server.We just put a 20 meg Fiber service into the Office. The issue we are having is it will still take 1-3 mins to load a web page. The DHCP on the router has been placed inactive for a block of IP and the Server has...

    greatjubee165 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:
  • Restore SharePoint 2003 database/s on SQL Server 2005

    I am not sure if this should be addressed by the SQL Server group or SharePoint Server group. Since I am more familiar with SQL Server than SharePoint I started here. We have SharePoint Server 2003 installed on Windows 2003 server running SQL Server 2005. We have been backing up daily, two of the...

    TLMercer45 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:
  • Name Pipe work arounds in SQL 2005 database

    I am working on a SQL 2005 data base, the supplirer is telling me that the reason I am unable to find the SQL Data Base when i run there Client install software through a VPN connection is that the Name Pipes are keeping the Data base from being accessed.   Can anyone herlp me with this issue I...

    greatjubee165 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:
  • Update a Date_Time Field

    I'm trying to update a DATE_TIME field to a NULL value. When I run the script below I get an error. Any ideas on what I'm missing? UPDATE Orders SET CONFIRMATION_DATE_TIME = ' ' WHERE ST_ID = 102690 ERROR: Msg 245, Level 16, State 1, Line 1 Syntax error converting the varchar value 'Ê' to a column...

    DJandLO130 pointsBadges:
  • Updating a Date Time Field

    I need to update the Confirmation Date Time field to NULL for a specific meeting but am unsure how to insert it.  The script below works for an individual but if they have more than 1 confirmation date it clears then all. Meet_Master.MEETING is where the meeting code AM2011 is. UPDATE   ORDERS...

    DJandLO130 pointsBadges:
  • Ageing Report T-SQL

    Im trying to write a query to retrive debtors ageing report in sql I have two tables [strong]1. Billing(billAmount,BillDate,AccountNo)[/strong] [strong]2.Payments(payAmount,payDate,AccountNo)[/strong] I need the output to show ageigng [strong]0-30, 31-60, 61-90, 91+[/strong] with the balances for...

    Sanisto45 pointsBadges:
  • Calling stored procedure in a database to query data in another database

    Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData...

    Ncs5 pointsBadges:
  • SQL Server 2005 backup server

    Is there a way to replicate a SQL server database to another SQL server with the same hardware and software? I want a live copy of the data up to date in case something goes wrong and we need to switch to the backup server.

    NewnanIT1,110 pointsBadges:
  • Renaming a SQL 2005 server

    What considerations and procedures should be followed when renaming a Windows server that is hosting SQL 2005? Previous testing has shown considerable applicaiton problems after a system rename. Thanks for the guidance.

    Labnuke9932,960 pointsBadges:
  • Optimize SQL 2005 databases on a schedule

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

    NewnanIT1,110 pointsBadges:
  • System tables in SQL Server

    How to view System tables in drop down menu of a database in SQL SERVER 2005

    VendoorMohankrishna5 pointsBadges:
  • Stop one database in a SQL 2005 environment

    If there are multiple databases ever one unique SQL2005, how can I stop only one of them?

    MoroExpert5 pointsBadges:
  • SQL 2005 Database instance

    Hi there i have a windows 2003 domain in our school, i have a problem with my sql 2005 database. im trying to uninstall a instance from the database engine. it wont uninstall. i believe that this is corrupt. im trying to reinstall sophos but as the old database will not uninstall sophos wont...

    Philcrox160 pointsBadges:

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