Hi, I believe my SQL server was configured as Case sensitivity. I have a number of stored procedures which were moved from a non-Case sensitivity SQL server. Because of the Case sensitivity, I have to do a lot of editing in those stored procedures. Is there a quick way to avoid the editing? ...more >>

I'm pretty new to SQL and querying, and I'm not sure if this is the correct group to post this to, but hopefully someone can point me in the right direction. I have the following query: SELECT Distinct dbo.DLFolders.FolderCode, dbo.PropertyCharValues.ParentId, dbo.PropertyCharValues.Doc...more >>

I have a SQL table with the following fields: accounts, orderid's and datetime Account OrderID Datetime 1 1 2007-03-01 09:30 1 2 2007-03-01 09:35 10 ...more >>

Imagine opening SQL Server Management Studio (SSMS), drilling into a database, and seeing all objects with little lock symbols in front of them. That would be true SS integration. Maybe next version? I know about creating a project in SSMS and managing connections, queries, and misc there, bu...more >>

We have a SQL 2005 server running the following backup job: EXECUTE master.dbo.xp_create_subdir N'\\Server\Backups\DBServerName\\DB_Name__METABASE' GO EXECUTE master.dbo.xp_create_subdir N'\\server\Backups\DBServerName\\DB_Name__MSCRM' GO BACKUP DATABASE [db_name__metabase] TO...more >>

We have a SQL 2005 server running the following backup job: <font face="Courier New" size="2"><br><font color="blue">/* Created by <a href="http://www.wangz.net/gsqlparser/sqlpp/sqlformat.htm">free online sql formatter</a> */</font><br><br> <font color = "blue">EXECUTE</font>&nbsp;<font color ...more >>

Someone at my job who was a IT Professional before me wrote a SQL statement. That statement or file is working with a program that we use called Papervision and the purpose of that SQL is to assign data to a table. I need help on how to locate this SQL file. I know it is running because it is ...more >>

Hello, I am trying to write a script using SQL Server 2000 to list all of the roles that have any permissions on a specified object (view, table, sp, etc.). Essentially I am trying to script what is displayed when one selects the 'list only users/user-defined database roles/public with permi...more >>

I was wondering if there is any online user reference/manual for transact sql (SQL Server) in PDF format? Download links? I know about online help but I would like to have something locally. Thanks. ...more >>

how to select 200 first records from table? --=20 Thank you, De Cool, EPE...more >>

I was checking out an indexes property via SQL 2005 Management Studio and it looks like I can move the index to other filegroups via the drop down. I checked the BOL ALTER INDEX and I didnt see an argument for this action. I see stuff about PARTITION, but I think that is for row partitioning?? ...more >>

I have a table with id an identity column. Can I forbid the identity column of taking the same values of deleted ones? How can I resolve this issue? *** Sent via Developersdex http://www.developersdex.com ***...more >>

I have SQL Server 2005 x64. I found in the studio I can generate all sorts of scripts, including the creation of indexes. I works, however the script contains the CREATE TABLE statements as well. I want the scripts to recreate the scripts on another filegroup (testing a theory from previous post...more >>

With help of others on this group, I've been learning and researching about indexes; an area I neglected. I see I can specify which filegroup I wish to create an index, which the default is Primary. I have more than one drive in my SQL server where I put data and logs on their own logical raid ...more >>

I need to run a SELECT DISTINCT query across multiple fields, but I need to add another field that is NON-DISTINCT to my record set. Here is my query: SELECT DISTINCT lastname, firstname, middleinitial, address1, address2, city, state, zip, age, gender FROM gpresults WHERE age>='18' an...more >>

hi, i have a column of type ntext in the db, we're using that to allow users to store essays they can enter. problem is when i'm running a select on the ntext column, data seems to be getting cut off, isn't ntext suppose to hold a lot of data, we wanted to allow them in a min of 1500 chars, wh...more >>

Hello, I have set up a database for movies. In one table (Movies) I have movie names, and production years, and also genres. In another table (Directors), I keep the directors and the movies they directed. Another table (People) keeps the names of the people. Everybody will have a unique ID. ...more >>

Hi, I'm trying to create views on all my existing tables and for that I'd like to create a script or so. I don't want to specify the '*' for the columns in the create view statement. I prefer to specify the column names. I have the column names int sys.columns table but Do not know how to ha...more >>

Hi, I know just about nothing about SQL Server. I am getting this error: The log file for database 'my_database' is full. Back up the transaction log for the database to free up some log space. I can't access the transaction logs to back them up. I am told that my ISP's tech support sh...more >>

Any Ideas as to this error message. I am trying to learn using ms sql server 7.0 Below is the code I am using for an update to a MS Sql Database. <%@ Language=VBScript %> <% Option Explicit %> <html> <head> <title>Sample Script 2 - Part 3 </title> <!-- copyright MDFernandez ---> <li...more >>

I thought I would delve into index fragmentation and I found some great sql from many posters (thanks Erland!). My question is how bad is bad? I know this is very subjective. Some scripts I found would reindex if the LogicalFragmenation is over 30%. I have some tables that are 98% (I'm guessing...more >>

Is there a way to select records that do not contain a certain character string in char, vchar or text fields? For example records where the email field does not contain the "@" character. Can't find it in the BoL. Chris ...more >>

After typing in the following I receive the Exception listed below: java -jar squirrel-sql-2.4-install.jar Exception in thread "main" java.lang.UnsupportedClassVersionError: com/ izforge/i zpack/installer/Installer (Unsupported major.minor version 48.0) at java.lang.ClassLoader.defi...more >>

Hello, I am wondering if anyone could help me in choosing a right training course. My company has agreed to send me on a training course for sql server administration. However it is up to me to choose the right training course available. i have recently took up a job of sql 2000 dba from a ...more >>

Hi there, I am re-organizing the database. We used to have field 'names' in our table for our first name and last name. However, I want to have those names in different field. FYI, I have two different tables in different databases. The A database contains A table with 'names" field. The B ...more >>

Hi, I have a C# web app that searches my database table using the following search parameters Search string, criteria (> < =) and the field you want to perform your search on. My understanding is that stored procedure is the way to go. What's the best way of doing this using stored procedur...more >>

I'm sure this has been brought up many times, but I will ask anyway. Let's say I have 2 tables related: Owner: --------- o_id o_name Dog: --------- d_id d_name o_id - for Owner table. If the data is laid out as o_id o_name 1 John d_id d_name o_id 1 ...more >>

Hi I'm not really a MS SQL Admin. I have only one system in our house holding an MS SQL DB. I need to made a backup of the DB. Can someone tell me what is the cheapest way? To buy Backup Exec is not an option. And I can't shut down the service while the backup is running... Regards a...more >>

Does anyone know of any documentation on the performance of partition merge/split? Does the merge or split of a partition cause any locking on the partitioned table? If you were merging or splitting a large volume of data rebalancing your partitioned table would you potentially lock users out?...more >>

Hi, I want the change the SQL listen port of a named 2005 sql instance. Is there a way I can run an sql query against the named instance which gives me back which registry setting I need to use. so MSSQL.1 MSSQL.2 or MSSQL.3 Or is there another way I can set the listenport through scr...more >>

I have a long query which I have set off and would like to stop, and rename one of the tables used. My query is due to my lack of understanding of the underlying structure of MSSQL-Server... So say and update updates TABLE_A and I stop it, whilst this transaction is rolling back I attempt ...more >>