• Problems with sp_send_dbmail in SQL Server 2005

    I am trying to convert my stored procedures in SQL 2005 from using xp_smtp_sendmail to using sp_send_dbmail. When I use the "Send Test Email" option in the management studio, I am getting the following error message from the sp_send_dbmail: The mail could not be sent to the recipients because of...

    Randym1,740 pointsBadges:
  • Upgrading two instances of SQL 2000 running on the same SVR to SP4

    I currently have two instances of SQL 2000 running on the same SVR. recently I commissioned a new CRM SVR and as I'm sure your all aware that the minimum requirement for the CRM to work correctly is SQL 2000 SP4. I downloaded and installed SP4 on the SVR running SQL 2000, however, my problem is...

    Cridgy35 pointsBadges:
  • SQL Server transaction log problem

    An error like" Transaction log full.. backup thelog and shrink the database .. " occured.. Many times the transaction log was backed up and shrinked.. Niow a stage has come where even doing the phenominal process.. the error still re occuring.. Afetr going thru a website transaction log was...

    1909198110 pointsBadges:
  • documents on sql server upgrade from 2000 to 2005

    Hello, If anyone has following documentation on SQL SERVER UPGRADE FROM 2000 TO SQL SERVER 2005, I will appreciate. 1) Pre-Checklist for the Upgrade 2) Process for the Upgrade 3) Post Check list for the Upgrade Thank you so much. If you kindly email me at cqldba@gmail.com, will appreciate thanks Sam

    Pslsql10 pointsBadges:
  • ROW_NUMBER in SQLServer

    In Oracle, I can use the analytic ROW_NUMBER function to assign sequence numbers to output rows, re-starting the sequence as certain values change (e.g., there's a separate count for each deptno in this example:) SELECT deptno , ename , ROW_NUMBER () OVER ( PARTITION BY deptno ORDER BY ename ) AS...

    FrankKulash1,240 pointsBadges:
  • view and temp. table which one works better in T-SQL?

    please tell me which one performs better view or temp table ?

    HL5 pointsBadges:
  • SQL Server Command String

    What is the max length of the Command String that can be submitted to SQL Server?

    Hank103925 pointsBadges:
  • Problem with MSSQL? .NET application? or Win Server?

    Dear members, Please help me in regarding my problem. I am very much confused on whom to blame for the problem........MSSQL? or .NET ? or Win server? I have a dedicated server with 2GB RAM, SQL 2005, 150GB bandwidth, 160 GB disk space etc., I have created a .net application that fetches data from...

    georgesmith55 pointsBadges:
  • SQL Server Schema Best Practices

    I am in the process of establishing a "sandbox" database for a mix of users with SQL development skills. I have done this before with Oracle but not with SQL Server. What I would like to do is build a database whereby each user has their own play area. We are running SQL Server 2005 so I thought of...

    MortimerSchnurd0 pointsBadges:
  • SQL 2000 to Yukon Migration

    We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for one of...

    Kilaru0 pointsBadges:
  • Triggers

    I was a cobol/db2 programmer for many, many, many years, and I now have the opportunity to work with SQL Server. That’s the good news…the bad news is NO training. I will have to learn this on my own. Do anyone have any suggestion on how to get started. My first project is to identify all of the...

    Mainframe dino0 pointsBadges:
  • database sql,with vb coding,first time running not fast

    we have an accounting package written in visual basic 6.0 and sql database,the problem is when we open the database the first time,it takes lot of time,but when we open it after, it will be very fast and remain fast ,even when we quit the application and restart it.

    Micus20050 pointsBadges:
  • SQL Server Tools do not show up

    Greetings, I have my laptop running MS SQL 2005. I upgraded from XP to Vista. When XP was installed, I had SQL 2005 Express and SQL Server 2000 running parallel. After installing Vista (clean) I decided to just go with SQL 2005. I installed SQL 2005 Express. Later, I installed the full server, and...

    Taersious15 pointsBadges:
  • Using MAX data types in SQL Server

    I'm new to using large data types (varchar(max))and after reading an article (Using MAX data types in SQL Server) I have a few questions. I am trying to understand how you insert such a long string (up to 2 billion char) in the database table? I am assuming this would include storing Word...

    Hank103925 pointsBadges:
  • Dynamic updates to a DNS Server

    What Windows Operating Systems support dynamic updates to a DNS Server? Which service needs to be running on the clients?

    1111100 pointsBadges:
  • What is NAT port forwarding?

    Describe in brief how you would set up port forwarding on a NAT router to allow a PC on the LAN to publish its web to the internet.

    1111100 pointsBadges:
  • DHCP relay Agent in DELL switches

    I have windows 2003 servers and Dell 62XX series switches (level 3 switches) and Vlans. As I understand in order for a computer to be able to receieve an IP Address via dhcp I need relay agent. This series of switches supports DHCP Relay my question is how would i assign computer to a specific...

    Dimchik0 pointsBadges:
  • Default User Profile

    I am in the unenviable position of administering an existing Windows2000 network consisting of one computer running Windows2000 server and three workstations running Windows2000 professional. They are configured as a domain. I would like to be able to set up a default user profile that would have a...

    Skyhawk8060 pointsBadges:
  • The time is wrong in one of my Domain controllers…………..

    Hi, There is something wrong in my domain from one week ago!!! I have two domain controller,the first dc name is DC and second is Mail,both of them is GC and the OS is Win 2003 server R2 sp1 I set the time of Mail and other clients by GP acording the time of DC: (net time \dc /set /y) I have some...

    Aliyani265 pointsBadges:
  • Lost Global Catalogue

    My Windows 2003 PDC recently died but prior to this I had transfered the operations master roles including schema master to my BDC. I was convinced my BDC was a Global Catalogue server but didn't get a chance to check before my PDC died. This happened just before I went away for 2 weeks and I only...

    ITBird15 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