• Syntax to reference a table on a database residing on another server

    I have the following insert statement: insert into Resident(Identifier_Type,Identifier,Full_Name,Dob,DL_Number,DL_State,Change_User,Change_Date,Change_PropID) select N'SS',Social,Full_Name,DOB,DL_Number,N'TX',Change_User,Change_Date,Change_PropID from N'haa-sql1.imisTest.dbo.Resident' I'm getting...

    MParkhouse5 pointsBadges:
  • Copying a SQL Server stored procedure with a query

    I want to copy a SQL Server 2005 stored procedure by using a query, much like the way a table is copied with one. Does a query exist that could perform this task for me?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Installing SQL Server Enterprise Edition on Windows XP

    I have two questions. First, how do I install SQL Server Enterprise Edition on Windows XP? And second, how can I find the SQL password without using an application?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Table size in SQL Sever 2000

    Please, I need a script to know the size of every tables in my DB. I found that my database is growing above what I expected,and I need to know the size of its tables.

    Yunior5 pointsBadges:
  • Stopping transactional replication from skipping a block of records

    Have you ever run into an instance in SQL 2005 where transactional replication is skipping a specific block of records? I have tried many troubleshooting techniques: dropped/created sub and pub, created new empty destination table, reinitialized and several others. New transactions come across just...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Implementing row level security in SQL 2000

    Is there a way to implement row level security in SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Finding the appropriate settings for copying tables within databases

    I have a table in a database that has 104456 records. I would like to copy the data to another table within that database. When I execute the command “insert into ChangeInsuranceTxnHistory select * from ChangeInsuranceTxn”, the following error occurs: "Could not allocate space for object...

    SQL Server Ask the Experts2,585 pointsBadges:
  • T-SQL how to identfiy tables that have dulicate roaws

    I have a MS 2000 SQL server. How can I search the db and indentify the tables that have duplicate raws. Thanks

    Techzon1225 pointsBadges:
  • Consistent error occuring in SQL Server 2005

    I have five servers in my network. On one member server, I have SQL 2005 Standard ver.9.00.1399.00 running on MS Server 2003 R2 SP2. In my event log on this server, I am receiving an error every couple minutes. They show up in the SQL error log as well as the event viewer. The error is: Event Type:...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Ask a question. Win an IT Knowledge Exchange T-shirt

    Community members Brent and I decided to put together a cool little contest. It is very simple. For the next week, starting today, all members that ask questions will be entered to win 1 of 5 IT Knowledge Exchange t-shirts we will be giving away. The more questions you ask the better your chances...

    ITKE345,300 pointsBadges:
  • i have windows 2000 server and isa server 2000 and we have some problems one is when i connect cmd then the command is arp -a then ip and phisical add

    i have windows 2000 server and isa server 2000 and we have some problems one is when i connect cmd then the command is arp -a then ip and phisical address show butt ip is different and mac address is same

    Sulaman5 pointsBadges:
  • MS SQL Server installing in the Livelink

    Hi there, I want to create a new Database ( MS SQL ) in the Livelink 9.7.0 , so which version ( MS SQL Server 2000 or 2005 ) is install in the Livelink 9.7.0 . If together can installed in Livelink 9.7.0 , whichever is better ? Best Regards, Abdullah from DUC

    A9944495 pointsBadges:
  • How to delete a duplicate SQL Server entry in a single redundant table?

    How do you delete a duplicate SQL Server entry in a single redundant table?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Executing a Stored procedure using Excel Macro

    I am an amateur in SQL programming. Could you please tell me how to execute a Stored procedure using Excel Macro (VBA Programming) and then save the record set into different Excel sheets?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Exporting large files in Reporting Services 2005

    Reporting Services 2003 uses a lot of memory for the Excel Export, making it impossible for files 15 MB or larger. Is this still an issue in Reporting Services 2005 or above?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using VB.NET to find local subscriptions on SQL Express

    I have several different SQL Express databases using pull subscription replication with a SQL Server. Different computers will have different databases to replicate with; some have more than one. Is there a way in VB.NET to find all the local subscriptions on the computer running SQL Express?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Storing attachments in tables on SQL Server 2005

    I am new on .NET and plan to migrate some applications to this new environment. I have a simple question – on SQL 2005, can you store attachments inside of tables?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Help with new installation of SAP CRM and supporting software

    We are going to Install SAP CRM 5.0 with Microsoft SQL Server 2005 and ECC 6.0 with Oracle 10g and integrate these with each other and also with QAS (Third Party tool). My question are: 1. Can we install all three applications on one single server as database is different or will there be issues...

    CRM Ask the Expert250 pointsBadges:
  • Data Sources for SSAS 2000

    I have a short term issue where I will need a SSAS2000 cube to be using data from a SQLServer2005 database. Can I do this directly? If not, can I Export MSSS2005 data directly to the MSSS2000 database? (Sorry for such a simple question- I am a newbie).

    Petro5 pointsBadges:
  • Table creation in SQL Server 2005

    Hi, I need to prevent users to use CREATE TABLE but I need them to be able to execute a stored procedure that creates a table. Is it possible to allow users to create tables in SQL Server 2005 only through a stored procedure? Thanks in advance.

    Alediamo10 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