Hi I am new in SSMA, I gotta use SSMA for Sybase, however I just find documentation for Oracle, is it the same for Oracle and Sybase?? or where can I found documentation? Thanks...more >>

With MS Access, I was able to use then SELECT INTO statement to move data between databases by the use of the IN clause to a newly created table in an external database, such as . . SELECT * INTO tablename1 IN 'msaccess database path and name' 'DBTYPE FROM tablename2 tablename1 will be a...more >>

Hi, I have install 2003 SBS (5 CDs) On new server,include SQL 2000. The problem is how to set up SQL server for client PC ocnnect?? How to setup client connection in PC?? Thanks! Danny ...more >>

Hello, I wonder, if there is a way to modify the Reports integrated in ManagementStudio. For exmaple I want to see the real size of the transaction log (Not in %). If there is no way, how do I get the Size from the systables? Best regards Hans ...more >>

Hi all, I'm pretty new to sqlserver (I have a little bg only in MySQL)... I would like to know if there is a query cache I can set somewhere to keep in cache used tables and so on.. thanks d ...more >>

Hello all, I am at my wits end here and hoping someone can lend some wisdom to this sql-noob. I have SQL 2005 on a Windows Server 2003 cluster: I am receiving the following error whenever I try to do anything with a DB (move, copy, backup, even create a new). "Cannot access the speci...more >>

Does anyone have know a good book for SQL starters 2000/2005 , not too teoritical with handson examples and sample code. I am an experienced Access VBA programmer. Would like to know how make 1) SQL VB.net applications including setting up the database. Upgrade Access applications to SQL back...more >>

I need to dislpay a table from an SQL database on a web page. I know how to make web pages and I have downloaded SQL Server Express and Vidual Web Developer Experss but don't know where to start. I just need a very simple display of a table that allows sorting by clicking on the column heading...more >>

Hi, all When we need a new database , we use the following SQL statement: Create Database database_name... In this statement, we can not use a string variable as database_name. Is there a way to use a string variable as database_name when we create database? Thanks ...more >>

is there a way for creating a direcory in a given path by Transact-SQL ? somthing like : MDIR C:\MyFold ...more >>

Hi , I am working as a Database Adim I am providing support Application projects Here is my issue, Can we able to provide access for a login only for 10days Is there is any other way apart from Windows Authentication ? Please help me Thanks in Advance Saran ...more >>

how can i find out by Transact-SQL the path to a certain db data file (mdf)? ...more >>

Hi, I just install SBS 2003 with SQL 2000 on my server, but when I try to use another PC (OS is WinXP) connect the SQL server throgh ODBC, it pop up a error msg: connection failed SQL state '28000' SQL server Error: 18452 Login fail for user 'XXX', reason : Not associated with a trusted SQ...more >>

Hi, We have MS SQL Server installed in a remote serve location. I need to run some queries on it. One of my colleagues in US uses Client services version to connect to te server and run queries. I also want to install the Client services in my computer (Windows XP Pro). The local IT asked m...more >>

Hello group, I have to convert some strings that I had on a Text field to Nvarchar. I don't care if some data gets lost. I tried this, but doesn't work because it's too long and complains about it: UPDATE mytable SET mynVarChar= cast(myInfo as nvarchar(4000)) ...more >>

Do you guyz know what rights are needed to run a SQL job (SQL Server 2000)? I have a friend that took away SA rights to a user and that user has dbo access to the database, but can't run the job anymore. What I think it is, they don want to give full SA rights back to the user. Any sugge...more >>

Hi all. I got the next very simple and strange problem. When running the following 2 slqs, one runs very fast, and one very slow. I looked at my indexes time and time again, and cannot figure out why. The table has about 8 million rows. Very fast: Select top 1 keyA from tableA where fiel...more >>

Is there anything in SQL Server Management Studio that will allow you to find text within tables, stored procs and views...not the data itself but within the data definition language? For example, I need to find all of the database objects that are using link servers. Thank you very much! ...more >>

One of the company's marketing department wants to measure the value of the data on potential participants that is purchased from business partners .The marketing department requires a view of the data that contains all potential participants to whom surveys were distributed and the names of s...more >>

Folks, I'm having a Little trouble figuring out how to add a table description using sp_addextendedproperty where the description has mixed single and double quotes such as: This table's description is "weird" Anyone have an idea? thanks....more >>

Hi Is it possible to reliably sync an access db with its equivalent sql server db using the built-in facilities of sql server and access? Thanks Regards ...more >>

I have SQL 2005 installed on a Windows 2003 server. I have installed Backup Exec 10d and get an error when trying to backup the SQL database. When I go to create a new backup job I can see the two databases ( one for Backup Exec and the other one for Solid Edge Insight Server and Sharepoint)....more >>

Do you guyz know what rights are needed to run a SQL job? I have a friend that took away SA rights to a user and that user has dbo access to the database, but can't run the job anymore. What I think it is, they don want to give full SA rights back to the user. Any suggestions or leads? ...more >>

I have SQL 2005 installed on a Windows 2003 server. I have installed Backup Exec 10d and get an error when trying to backup the SQL database. I can see/backup the Backup Exec database but when I try to click on the other database ( used for Sharepoint and Insight ) it gives me this error... ...more >>

I'm trying to use sp_changeobjectowner I'd like to change the owner on all table names that begin with "tbl". sp_changeobjectowner "tbl%", "Sam" doesn't work. what do I need to change? do I need to label it "dbo.tbl%"? Thanks. ...more >>

My computer-based training piece sends user data to asp pages which relay the data on to a SQLServer 2000 database. All works well with one exception: when a new record is created, any spaces in the string containing the user's name are deleted. When the training piece sends the variable ...more >>

I have SQL Server 2005 Developer Edition, I am currently in the process of installing SP1, on XP SP 2. I have looked through previous posts here concerning import/export and have worked out that I need SSIS, but it doesn't appear to be installed on my machine. I have Configuration Tools, An...more >>

I have a list of values that I need to insert into a SQL table. The list of values is stored in a .txt file. What would be the syntax of the insert into query be and how would I reference the .txt file. Or, is there a better way to get the values added to the table? TIA, RC- ...more >>

Hello all, Using SQL Server 2000 (Standard Edition, I think) I was under the impression that File or Filegroups backups just backed up the data file at that point in time and that the log files were insignificant. Apparently I was wrong and now I'm having trouble trying to get the DB operat...more >>

Hi all... Another question, can I install the SQL Server 2005 Express Edition on my XP Pro SP2? Are there any preliminary requirements that I need to look at before doing so? Jan :) ...more >>

Hi all :-) Do I need to have a server in order to learn how to use the SQL Server 2005? Jan :) ...more >>

We have pharmaceutical databases that get purged and repopulated nightly. The tables range from 20K+- records to 55K+- records. Before these maintenance routines (stored procedures) run we'd like to disable transaction logging and then enable after completion. Thanks in advance...Tom ...more >>

I need to run a query that will pull all of the data with in a certain date range. I can't seem to figure out the syntax for the query in SQL. In MS Access, this query works perfectly: SELECT MASTER_APM_VENDOR.Vendor, MASTER_APM_VENDOR.Name, MASTER_APM_VENDOR.Last_Inv_Date FROM MASTER_APM_...more >>

I installed Visual Studio .NET 2003 (Enterprise Architect edition) on my PC (Window XP Professional edition). Then I downloaded and installed SQL Server 2000 Desktop Engine (MSDE 2000). The installation did not produce any error messages, so I assume the installation went ok. But how do I set ...more >>

Hi Group, I have the following problem: I am running the Enterprise Edition of SQL Server 2000 SP4. I am trying to start the server in Single-User-Mode but it isnt starting. Thats what I am getting: 2006-05-11 10:09:22.12 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May...more >>

Hi @all, I have got a very short and easy question. Is there a way to install SQL 2000 Server on a Windows 2003 Small Business Server Standard Edition? I tried to install the Enterprise Edition of the SQL 2000 Server but I got a message, that I was not allowed to install that software. The ...more >>

I installed VB 2005 Express and MS SQL Server Express just last week; my SQL Server is 9.0.2047 according to MS SSMS Express. I built a small database for my VB application according to the procedure in the VB help "Creating Your First Database - Microsoft Visual Studio 2005 Express Editions Do...more >>

hi i make smal Application to get information from SQL Server 2000 by using VB6. now i can get Databases, Tables and Colomn, and Stored Procedures, but my problem how i can get SP Parametres? i am thinking to make small function to get Parametres From SP.Text, but i think its not good solut...more >>

hi, a table contains which groups users are allocated in: UsersIngGroups: UserID int GroupID int A table allocates restrictions to web pages - if user's group is matched with ItemID, that particular User/Group has access; Restrictions ItemID int Group int Since users can be i...more >>

How do I rename a database on sql server 2000? I have a database I brought up from a backup and has the same name as the current database. I don't want to detach the current one because I have to get data from both databases. I tried renaming the file name of the backup copy, and in the a...more >>

Hi, I installed sqlserver 2005 express on windows server 2000 sp4. I made a new database ("mydb") with sql server Management studio express (not a mdf file). I also defined tables and i can make and execute queries in sql server Management studio express without problem. I granted to accou...more >>

Hello, Using query analyzer is it possible to rem out a query so it can be used again? Any assistance would be appreciated. Femi ...more >>

Is it possible to post an mdf database file into a folder on some webserver and then develop a VB.Net application that would access that database ? The folder on the server would know nothing about an SQL Server. It simply holds a mdf file. BR Bob ...more >>

In SQL2000 there is a tool to import CSV files. Where is the import tool in SQL2005? Bob W ...more >>

hi, i'm new to this group. i wonder if i can get answers to my question here, cos i cant find a newsgroup with database mirroring. i have two servers : pSQL - principal mSQL - mirror Have successfully create the endpoints at both servers. Have checked on the port 5021 listening at both...more >>

how can i able a user to add new login from whithin the application . when user runs a passthrough query with the sp_addlogin command there is a message that user does not have permission to this action thanks ...more >>

Hello all, Using SQL Server 2000 (Standard Edition, I think). I was trying to educate myself on creating functions and in one of the examples in Books Online I noticed that you could use formulas in fields in a table, calculating the field value using other fields as arguments. My questio...more >>

Hi All, I'm hoping someone may be able to help me out. We are running multiple databases on our SQL Server. I would like to create a test environment based on the existing databases. (Because I'm new, I don't want to mess up what is there) I have been trying for a week to copy, backup & rest...more >>

I downloaded the trial version of SQL Server 2005 to facilitate the migration of a web site database from a SQL2000 server to the new host's 2005 SQL Server. It transferred the data itself OK, but I found two major problems with the structure: 1. All my Views were created as Tables inste...more >>

I have a SQL 2000 Server database on my windows xp pro pc. I would like to have my Access Data base Office XP PRo SP3 Link to the SQL database so I can run queries and reports in Access. How do I do that? Any exmples would be helpful Thanks Tom ...more >>