This may not be a newbie question, but I consider myself a newbie.

I use this query in 'Query Analyzer': SELECT TOP 100 PERCENT dbo.customer.username, SUM(dbo.ihe…

Moving Registered server from one SQL client to another.

This has always been a nagging problem for me.  The laptop/workstation in our company are leas…

What is going on behind the hood of SP_EXECUTESQL??

Hello *,  I know that sp_executesql executes dynamic t-sql, however, is there a way to look at…

Can''t copy first row from txt

Greetings. I'm trying to upload from a text file, but the first row doesn't copy. The text file has…

Disable Job

When our mail server is down (unfortunately, not an uncommon event), all of the scheduled jobs usin…

Trying to use two "linked" tables on the same report with different datasets

I have two tables.  The first table I am showing the customer's prices.  The second table…

[microsoft][odbc sql server driver]timeout expired

Hi, One of my users created a query in EM and received this message when he ran it.  He came t…

Duplicates

I have a table like below with 1M+ rows:   ID    col1    col2&nb…

Evaluate Ratio

Hi,   I have a column which is stored in database as varchar.The vaue it contains is like '1/8…

Syslogins and passwords

inserting from TXT file and creating the table...

i load leads for a telecommunications company, a problem i'm having is the client will send a txt f…

error- Timeout Expired

Hi everyone I have installed SQL server on my server machine. using username,password,domain and mi…

Please help qith SQL

This is the problem:   I have a field named CitationID in a table Named CitationMaster the dat…

Rollback process slow

We ran DELETE process and later killed it. Now, we have a rollback process that is taking a very lo…

error while installing sql report service sp2

Hi, I'm trying to install Reporting service sp 2. My sql 2000 server is installed in another server…