• MSSQL Stored Procedures

    So im in my first year as a programming student and im stumped on a database i need to go alongside its stored procedures. Sorry beforehand if my english isnt that great,its not my native language.Anyways the database(tables) goes like this: Customers(CID,Name,LastName,Telephone) CID being the key....

    Yrrtni5 pointsBadges:
  • MS SQL and IBM BLADE

    Is MS SQL compatible with IBM Blade HS21?

    Darqtanian5 pointsBadges:
  • USE DATABASE

    How can I write a stored procedure which can switch to new databases using something like "use DBASENAME", but without knowing the dbase names before the procedure runs? The example below was my attempt to do this using SP_EXECUTESQL. The reason for this is so that I can call stored procedures...

    RMIS0 pointsBadges:
  • Clustered indexes

    Why can only once clustered index be created on a table ? What is a row locator?

    Satya teki0 pointsBadges:
  • 7 SQL Servers working seperately need joining.

    I am working in small bank with 6 branches and a Headquarter. Each Branch is running a SQL server with 8 workstation connected to it over LAN. At each day end branches closes their work send their data to headquarter in an export file format. Where it is imported to Headquarter Sql Server database...

    Naveed Khan0 pointsBadges:
  • MS SQL 2000 memory leak

    Hi We are running Adobe Workflow server which is based on SQL 2000. Both appliaction and SQL 2000 rside on the same server WIndows 2003. Lately we faced the problem of Time Out from Adobe and it seems to be that SQL is consuming allot of memeory. When checked Tak Manager we found out that...

    Alexandria0 pointsBadges:
  • Indexing Fact Tables for a data warehouse

    Hi I am reviewing the indexing the fact tables of a data warehouse and it currently has a clustered primary key and quite a few VERY LARGE covering indexes comprising lots of columns. The selectivity of the columns other than the primary key is very low; mostly close to 0% with a couple around 15...

    Garp0 pointsBadges:
  • Disaster Recovery

    How to get database back in disaster recovery when database is in emergency mode in sql server 2005 is there any option to update master then take a backup --please let me knw---

    Vaibhavmathur0 pointsBadges:
  • connecting VB2005 Express with remote msSQL2005 Express server

    I'm trying to do the above with no sucess although I can connect msQuery, create msAccess projects, and ODBC with the remote server. The remote server is already configured to accept remote connections.!!! the message is that the remote server do not allow remote connections!!! any ideas

    Teqani0 pointsBadges:
  • sqlevn70.rll error

    "Your SQL server installation is either corrupt or has been tampered with (Could not open SQLEVN70.RLL). <I have been getting this error during bootup since i cleaned my registry and messed with startup programs. im still learning so basic instructions would be appreciated.

    Wdpless5 pointsBadges:
  • Triggers in sql server 2005

    hi Experts, I have created a table called MyEmployees with ManagerID,ContactID,etc.,.. fields. Also i created another table ManagerAndContact with Only ManagerID and ContactID as fields. Now what i need is, whenever am inserting a new row in MyEmployees table, the corresponding ManagerId and...

    Kmm0 pointsBadges:
  • Systems problem

    I always wonder why this happened to my system.....a situation like this. I redesign my system since its predecessors made me a lot of headache. The previous months after it was been upgraded many complains in one particular problem. This is what the problem is......they notice that in no...

    Jdcruz10 pointsBadges:
  • Interesting Outout in SQL SERVER

    Folks, If I query like this, am getting the following Output.. Y is this so ??? SELECT 10_to_100 _to_100 ----------- 10 SELECT 25_from _from ----------- 25 If anybody is familiar with the reason, y the part of the data in select query getting truncated.. pls share... :) cheers ! ash

    Ashok tak0 pointsBadges:
  • SQL 2005 Restore DB with Multiple files in Primary File group

    Is it possible to take a backup of a database that has multiple files within the primary file group (10 total in this example) and restore that backup to a new database that has only one file in the primary file group? THanks, Lee

    Leeland0 pointsBadges:
  • VPN & CISCO 2610 setup

    Hello Sir/Madam, I cannot access our VPN from the internet outside our organization. I am using Cisco 2610 Router with IOS v12.3. And i created the access-list for the inbound and outbound connections. I have mentioned the access-list below and also i mapped a static IP address with the VPN...

    Parames0 pointsBadges:
  • Showing all records

    DATA SET: Table1 XID YID WRKDATE --- --- ------- 1 NOR 2007-01 2 SOU 2007-03 Table2 XID ZID QTY --- --- --- 1 PEN 10 1 PAP 20 2 PAP 5 1 PEN 10 2 PAP 5 Result XID YID WRKDATE ZID QTY --- --- ------- --- --- 1 NOR 2007-01 PAP 20 1 NOR 2007-01 PEN 10 1 NOR 2007-01 PEN 10 2 SOU 2007-03 PAP 5 2 SOU...

    TeamJR315 pointsBadges:
  • Report Properties Code

    Where can I find information on how to use the Report Properties Code

    JTHogan5 pointsBadges:
  • simple remote administration

    hey y'all... is there a way to do the following remotely? change passwords create a share on a server hard drive I have the adminpak installed on my workstation which allows me to do it. I want to be able to do it from ANY computer on the network. I have Win2k3 servers only, and WinXP clients only....

    TheVyrys0 pointsBadges:
  • Running Syantec Antivirus on a Windows Domain Controller

    I am currently in the process of deploying Symantec AntiVirus Corporate edition in my Windows-based network. In the manual it states, Do not install the primary management server on the following: Miscrosoft Exchange Server, Web server, or programs that prevent you from restarting the computer at...

    Skepticals0 pointsBadges:
  • R2

    does anyone know if windows server R2 is compatible with exchange 2003?

    Wolfden0 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