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?

Answer Question   |  May 27, 2010  5:24 PM
SQL 2005, SQL 2005 Database, SQL Database, Stored Procedures

Subquery only returns column names
I have the query below, but when I run it, I can only get column names to return. Can someone please help me??? For each subject there are multiple values at each marker. I want an average, by date, for each subject at each marker. I have spent literally hours on this… Thanks in advance [...]

Answer Question   |  May 27, 2010  12:42 PM
SQL Query, SQL Server Query, Subquery

Sql Server CAL
I have a Sql Server Enterprise 2005 64X, installed licesed by processor, I what to cut budget so thougt if I change to CAL licensing could save money, but know how to calculate how many users are currently conecting to my server. How can I get this info?

Answer Question   |  May 27, 2010  9:29 PM
SQL, SQL Server, SQL Server CAL licensing, SQL Server Enterprise Edition

How to find who called a stored procedure
I would like to know what process or stored procedure called one of my stored procedures. Is there any way of getting this information from SQL Server 2005? Thanks in advance, Ed

Answer Question   |  May 28, 2010  2:37 PM
SQL Server, SQL Server 2005, SQL Server 2005 SP3, Stored Procedures

Sponsor Post: Live Expert Chat 6/1: Drive Your Business Forward with SharePoint 2010
Join us for the next Microsoft Live Chat on Tuesday, June 1 at 11 am ET. SharePoint 2010 allows your company to quickly respond to changing business needs. Your people can share ideas and expertise, create custom solutions for specific needs and find the right business information to drive your business forward. Sign up for [...]

Answer Question   |  October 31, 2011  2:18 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, ITKE, ITKE Community, Linux, Lotus, Microsoft Live Chat, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

SQL Syntax Error SQL0104
I have to recreate a duplicate logical file, but I can’t use the crtdupobj command because it doesn’t recreate the correct library pointers. Using the dspfd command. I’m attempting to recreate the logical file in a different environment(library). Using the exact same commands (different library) I’m attempting to create the file in SQL using the [...]

Answer Question   |  May 26, 2010  6:37 PM
SQL, SQL error messages, SQL Statement Syntax Errors, Syntax errors

Linking Access to SQL Server
Hi ive got alot of linking tables in Ms Access and I want to link in onto Sql Server 2005.how to i do the liking part

Answer Question   |  November 9, 2010  6:52 AM
Linking Access and SQL Server, Microsoft Access, SQL Server, SQL Server 2005

File access restriction for users in Logmein
Hi, Please let me know whether logmein has a feature to restrict access of certain type of files for users. For example we have sql database having customer,account details etc.We need to restrict user who connects remotely to not to access account related files.

Answer Question   |  May 25, 2010  3:46 AM
LogMeIn, Remote access, Restricted User Group, SQL Database

Java Code to Copy AS400 file to SQL Server database/table
I need Java code to access and copy an AS400 file to SQL Server database/table. It must also copy a specific amount of records from the SQL Server side. 

Answer Question   |  May 26, 2010  7:24 PM
AS/400, Java, Java code, SQL Server, SQL Server database

SQL Server schema
Hi,    How can i get the user names assigned to the Schema through (T-SQL) Regards; Rino

Answer Question   |  May 25, 2010  10:51 AM
SQL Server, SQL Server schema, T-SQL

anybody can tell me that how to create setup which will accept database name & server name
anybody can tell me that how to create setup which will accept database name & server name trhough which i can create database in perticular server during setting up the application. i mean to say i don want create manually in sql Server, which should be created during sepup only

Answer Question   |  May 24, 2010  10:23 AM
.NET, Database name, Setup and deployment, SQL Server, SQL Server name

Data Warehouse Query Performance
We have a data warehouse with summary and detail level data with Cognos as the reporting tool.  If we have data for 100 large customers loaded in the fact tables and are trying to use Cognos Query Studio.  Here is the scenario:  one user has access to data for 5 customers through the security layer [...]

Answer Question   |  May 21, 2010  1:24 PM
Cognos, Data Warehouse Testing, SQL Server

alter database
HI, when i run the command alter database northwind set multi_user with rollback immediate the northwind database shows ACCESS denied and tagged as SINGLE USER i donot understand why it so .can u pls explain .

Answer Question   |  April 11, 2011  10:36 AM
Northwind sample database, Run Commands, SQL Server

change track in sql server 2008
HI, use Northwind Alter database [db_track] set change_tracking=on (change_retention=3 days,Auto_cleanup=on) i m running the above  command i m geting the ERROR AS Msg 5011, Level 14, State 5, Line 3 User does not have permission to alter database ‘db_track’, the database does not exist, or the database is not in a state that allows access [...]

Answer Question   |  May 25, 2010  7:16 AM
DB tracking, SQL Server, SQL Server 2008

Which tool is best in all aspects?
Which tool is best in all aspects – speed, performance, user friendly, to do all activities etc - PL/SQL Developer or SQL Developer or TOAD

Answer Question   |  May 20, 2010  6:38 AM
Oracle, PL/SQL Developer, SQL Developer, TOAD

Would using a table variable from a function be efficient?
We divided our tables from table zone_a, …_b, …_c to zone_z, these tables have the same attributes. We have divided this tables in this way so that any data that is under zone_a would only be on it’s specific table, and the same with the other remaining table. Since per table holds thousands of data [...]

Answer Question   |  May 19, 2010  7:16 AM
MSSQL, SQL tables, SQL variables

help me create trigger update column
CREATE  TRIGGER Trigger_UPDATE_BIENLAI_TIENNOP ON BIENLAI FOR UPDATE,INSERT,DELETE AS IF (@@ROWCOUNT = 0) BEGIN PRINT ‘ TABLE is null’ RETURN END IF UPDATE(TIENNOP) BEGIN UPDATE BL1 SET BL1.TIENNOP = BL3.TIENNOP FROM BIENLAI BL1,DELETED BL2,INSERTED BL3  WHERE BL1.SOBL = BL2.SOBL AND (BL3.TIENNOP < 300000)  PRINT ‘ finish update ‘ END /* trigger not check ‘ BL3.TIENNOP < 300000′ [...]

Answer Question   |  May 19, 2010  7:03 AM
MySQL, SQL Syntax, SQLite

Add an Active node to SQL Server Active Passive Cluster
how will i add an active node to an existing Active/passive SQL Server 2005 Cluster. so that when any active node fails the passive will be used.will there be a down time for the current cluster Jasina

Answer Question   |  December 9, 2010  8:35 AM
Active/Passive SQL Server 2005 Cluster, SQL Server 2005, SQL Server clustering

sql server 2008 backup and restore
can u get me the command to recover the database . my backup is in d:nor.bak . as i m running the command   >restore database ‘d:nor.bak’ it gives me the message as : Incorrect syntax near ‘d:nor.bak’. pls let me know how to reatore . Regards, Rino

Answer Question   |  May 19, 2010  6:46 AM
SQL Server, SQL Server 2008, Sql Server 2008 Backup, SQL Server 2008 error messages, SQL Server backup and restore

Looking for Backup solution for VMWare environment
We’ve started adding VMWare servers to our data center, and we need a backup solution that works. We’ll have a mix of ESX4.0 and ESX3.5 hosts along with vCenter 4.0. Host will have Windows 2003, Windows 2008, RedHat 4.x and 5.x. Some hosts will have MS SQL 2005 and Oracle DB. We have TSM deployed [...]

Answer Question   |  August 11, 2010  2:09 PM
ESX4, SQL 2005, TSM Backup, Veeam, Virtualization in 2010, VMware Server