SQL Server Tools - Week 9, 2005

Combining multiple columns into one column.

Jir - 26 Feb 2005 5:05 AM - 2 messages

Dear all, I am having a problem on how to merge 3 columns into one column. I have a columns named [LastName], [FirstName] and [MiddleName], I want those columns to be as one and name it as [Name]. How will I do that? I already tried the ...

parameters

Bob - 25 Feb 2005 10:24 AM - 2 messages

Does anyone know where I can find excercise examples on parameters Thank you ...

sysadmin

Bob - 25 Feb 2005 9:09 AM - 3 messages

HI All Can a sysadmin be denied of a select statement? Id you ad a user to the system administrator then deny them rights to a column can they still use a select statement? ...

Catch and analyse incoming queries

Sergi - 25 Feb 2005 8:02 AM - 2 messages

Can I programatically (from f.e. c# program) catch incoming queries to an SQL server? I want to watch and analyse them, if such queries are create/alter/drop I want to log this information in a database to view ...

Compress text column on SQL2000

Vitamin E - 25 Feb 2005 12:25 AM - 9 messages

I am trying to compress text/image column on a table on MSSQL200 Enterprise Ed. When will compress when write to the table and uncompress when user retrieve the data. Anyone can please suggest me how to or any tool to do this. ...

Get Size of a dedicated table

Pete Smith - 24 Feb 2005 11:15 PM - 2 messages

Hi, I'd like to analyse my db. Does anybody how to get an overview about the table sizes? TIA Pete ...

using script files for osql

Bevo - 24 Feb 2005 10:29 PM - 2 messages

I have a script that calls other scripts using osql. I am using the :r function to call in the other files. First question, is there a better way than using the :r convention? Using the :r convetion, I am getting an error that seems to indicate GO is ...

hot backup

Ken - 24 Feb 2005 4:11 PM - 8 messages

any good Hot Backup tools recommend ? thx! ...

SCRIPT

BOB - 24 Feb 2005 2:03 PM - 2 messages

Hi I am very familiar with insert statements, but how does a value get passed for a user name and password from either a web or windows application i.e A simple insert statement would be Insert into Table1 (username,password)values('bob','password') ...

Creating Database Diagrams

Sudhakara.T.P. - 24 Feb 2005 12:13 PM - 2 messages

Hi, I have 5 tables each in two databases database1 and database2 in SQL Server. Now, I want to create a database diagram for documentation purpose in database1 wherein I want to include the tables in database2. Is this possible. If yes, how can I do this. ...

SQL Script

Bob - 24 Feb 2005 9:57 AM - 2 messages

Hi I am very familiar with insert statements, but how does a value get passed for a user name and password from either a web or windows application i.e A simple insert statement would be Insert into Table1 (username,password)values('bob','password') ...

Error when running a Query

Roger - 23 Feb 2005 10:31 PM - 5 messages

In query analyzer, when I have a cursor that runs through some code enclosed in the begin and end statements. But, if the cursor dataset is larger then 20 records, on the 20th record, it will give me this error. ...

[MS Design Tools] - Class Not Registered

Ryan - 22 Feb 2005 7:21 PM - 2 messages

On a Windows 2000 pro workstation I am using SQL 2000 enterprise manager I am trying to return all rows, I get the error message "An unexpected error happened during this operation. [MS Design Tools] - Class not registered." I have reinstalled the client tools, reinstalled service pack 3a, but I ...

Exporting ToExcel file

SalamElias - 22 Feb 2005 5:53 AM - 4 messages

Hi, I have a SP that adds an Excel file as a linked server, then tries to send the result of a query into this file. I get the following error : ------------ OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication ...

Importing MS Access queries and relationships to MS SQL Server

Jir - 21 Feb 2005 8:45 AM - 2 messages

Dear fellow programmers, I am having a big problem on how to import queries and relationships from MS Access to SQL Server. Any suggestions will be a great help & will be appreciated. Thanks in advance, ...