Hi, I am experiencing a totally unexplainable date behavior, coming out of the blue, without warning, I don't understand anything any more. Let me explain: I am using Dreamwaever MX 2004, ASP, VBScript, and SQLServer 2000 as DB. I am developing since a while an application, and I am near...more >>

I have a SQL2K instance that has granted me access through an unusual setup. The SQL2K instance has granted me access through BUILTIN\Administrators by including "NT_Authority\Authenticated Users" as part of that Windows Group. Based on that, using DMO and C#, I need to be able to determine th...more >>

Hello -- we have SQL Servers running in a Service Bureau environment. How clients frequently use applications at their sites to access our SQL Server. Unfortunately, some of our clients are more sophisticated than others and know about Enterprise Manager and Query Analyzer, which they can try...more >>

One quick question....I have a MedicalCause table and it contains 12 billions of records and I wanna do partitioning that table and wanna create view as well as index on that view but the problem is the that SQL server doesn't allow to create an index on view which contain "union" and I have to ...more >>

Working Fine : select top 5 * from MedicalHistory Doesn't work : select top 5 * from MedicalHistory order by 1 Doesn't work : select top 5 * from MedicalHistory order by 4 Doesn't work : select top 5 * from MedicalHistory order by 2 MedicalHistory is basically a Partition view.... ca...more >>

Here is the quick question, i have created MedicalHistory Partitionned view and it's working pretty good.. when I write this select top 1 * from MedicalHistory ... result comes in a second but when I write this query.. select top 1 * from MedicalHistory order by 1 desc... result will not come ti...more >>

Can any one tell me regarding the foreign key constraints like I wanna findout which columns doesn't contain the foreign key constraint so that I can create it.... Thanks in advance. ...more >>

Hi all, I'm trying to develop a Java application that will manipulate and transfer data from sql server X to sql server Y. I'm pretty new to this sort of thing, but how can my Java application be notified when a record is updated/inserted into X so that it can be stored in Y? Does Ja...more >>

USE PUBS GO CREATE FUNCTION [dbo].[GetSpace] () RETURNS int AS BEGIN RETURN (SELECT max(len(fname)) + 1 FROM employee) END GO SELECT top 5 fname + SPACE([dbo].GetSpace() - LEN(fname)) + lname AS Expr1, [dbo].GetSpace() AS Expr2, LEN(fname) AS Expr3 FROM dbo.employee When I...more >>

I think my mind is going. I once new how to do this but have somehow forgotten. We have SQL 7.0 loaded and has been running for several years. Also the SQL client tools are loaded and are working fine. What I need to know, is how to install , MSSQL client, on a PC that needs the SQL client to ...more >>

Hi guys, I'm having troubles with transaction control. I recently decided to add transaction control to some operations on an app I am developing (Dreamweaver MX 2004, ASP, VBScript, ADO and SQLServer 2000). I started by doing a test web page with an update of up to 3 different tables...more >>

I have a large xml file around 500 MB and I used to insert the data every day in one table, the issue is that I only want to use SQL Server to do this whole process. No VB and no asp envolve. Any idea? Thanks ...more >>

I am using the following query for fetching the data from the txt file..... but failed to do so.... select a.* from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\xml;','select * from Test.txt') as a Test.txt:- <ROOT> <Customer CustomerID="VINET" Con...more >>

What are the major difference b/w index hint and creating index on column Thanks ...more >>

if we create 1000 database users then is this create adverse effect on the master database? Thanks ...more >>

What are the maximum limitation of database user ? ...more >>

Any possibility? Right now I have a 600 MB space free and on my system I have a 6 GB backup file and I want to restore it on my own system.... I don't have any network where I have place this file and restore it from there and no DVD which support this 6 GB.... any possibility like when I res...more >>

I have created two jobs.. First Job... take the full backup daily at 12:00 AM Second Job...take the log backup every 1 hour till 11:PM The question is that if I include log shrinking command in the first job like First Job :- Step 1:- Declare @SQLStatement VARCHAR(1000) SET @SQLSta...more >>

Can we have more than one column alias for a sinle column in the select list. Something like this SELECT field1 A,B FROM Table...more >>

Can any one give me some idea regarding the major difference between working in Clustering environment and Non Clustering environment with respect of SQL SERVER. Thanks ...more >>

I am trying to take the backup into another machine which is on the network but failed to do so.... Like backup database Health to disk = '\\nSys0120\Backup\Health\bkHealth05172005' is the above command is okie ? Thanks ...more >>

I used "set statistics profile on" but I wanna know what are the most important columns to be considered like "Warnings", what others? Thanks ...more >>

I want to remove all the procedures from the cache... I used DBCC FREEPROCCACHE but doesn't effect. Any idea? Thanks in advance. ...more >>

I have find out one long running query through SQL Profiler and I copy that stored procedure and run in to query analyzer with the following settings. set statistics profile on set statistics io on set statistics time on In the output of warning column I found Null with all of them but wi...more >>

I just want to confirm from you that is this is the good practise if I can take full backup which size is 4 GB and log backup into another system instead of same system.... right now what I am thinking is the size of the backup is too larget so the network would be too jam if the full backup wou...more >>

Error while taking the backup..... I used the following command backup database test to disk = 'e:\bktest05172005' "e:" is basically a map drive. Error : --------------------------- Windows - Delayed Write Failed --------------------------- Windows was unable to save all the data for...more >>

Hi Here is the situation. Many clients simulteneously update the same table, but *never* the same rows. Each client has its *own* subset of rows. So there is theoretically no concurrency problem. Yet we are having locking issues. We use ROWLOCK hint but it looks like it does not do anyth...more >>

What would be the best practise to update the statistics like after how many DML transaction. Thanks ...more >>

Here is the following stuff which I do for recovery log file ... basically I have lost log file and I only have a .mdf file. Before going to the DOS mode I update the status of Health Database to 32768 and I only have a .mdf file. From the DOS mode I used the following command sqlservr -c...more >>

In the the dos mode I want to search in the SQL Server binn directory like show me all the file which start from SQL like in database we can write select * from tablename where fldname like 'sql%' any idea in DOS how can I search all the files start with SQL ? Thanks ...more >>

sqlservr -c -T3608 -T4022. Can any one let me know about T3608 & T4022 means ? I have failed to findout in BOL.. Thanks ...more >>

Hi.. We're developing an application against an SQL Server, that is the developers have an SQL Server installed, but the end user will only have MSDE installed and no SQL Server will be used at the end user's site. When trying to run the generated app. on the end user machine with MSDE it ...more >>

I am not able to start the MSSQL Server service on my system ever since I shifted my house and got a new network provider. Earlier, I was on the local cable hub, now my computer is on a DSL network. I don't know if the network would have something to do with it, but I am just providing informati...more >>

I only have a MDF file not the log file and I used the following command ...... EXEC sp_attach_single_file_db @dbname = 'test', @physname = 'C:\test_Data.MDF' Error: Server: Msg 1813, Level 16, State 2, Line 1 Could not open new database 'test'. CREATE DATABASE is aborted. Device ac...more >>

I just want one confirmation like I have create one job which take daily full backup in the night at 1:00 AM and the other job which took log back every 1 hour, should I shrink the log before taking the full backup or after taking the full backup I have to shrink the log file? Thanks ...more >>

Currently our database has Ansi_Padding turn off but we have many cols in tables which have trailing white spaces. I need to find a set up or SQL set command to remove all the white spaces which trailing the Varchar field type. Please hep...more >>

Can any one have any idea regarding the Yukon 2005 event in Toronto in the near future, we want to attend the seminar...... or which microsoft support email I can ask for that Thanks ...more >>

Hi All, We are running a job for archiving old data. The job calls a stored procedure. The data gets copied successfully to a different database but when a query is run to delete the data from the source database, it does not get completed. What is it trying to do ? Why does it not move ...more >>

I am running mssql server for a sharepoint site. I have a mssql .bak file that needs to be converted to plain text sql queries. Is it possible to convert it somehow? ...more >>

Still little bit confused regarding Statistics updates and rebuilding indexes..... can any one give me one basic difference. ...more >>

Please correct my concept, as I am thinking when log backup it auto shrink the file to its mininum point like when I take the log backup and see the size it's still on the same size but yes when I shrink the log then it's goes into minimum size so now the point is like I do take only the log bac...more >>

I am creating one Call centre database and application. The issue is that application will hit every 2 seconds to database for checking calls so is there any optimized way I can use like instead of hiting the database every 2 seconds I use any alternate way ? Thanks ...more >>

Does anyone know if the reporting services is an add-on to the SQL server license or does it have its own license that must be purchased?...more >>

If I want to save the Chinese, French and English data in a single table so the column datatype would be nvarchar right? ...more >>

I am creating one batch file which move datafile and logfile into different machine but I want to ask one question like if one command successfully executed then I have to wait for 20 seconds and then execute the second command ..... can any one know the command which I can use in batch file.... ...more >>

Can any one let me know like how can I remove one directory, which contains couple of file, through xp_cmdshell extended stored procedure. Thanks in advance. ...more >>

Jens, I have tried to do what you have suggested. If I take a snapshot of different areas of my PC and upload them to my website and furnish you the URL so that you can view the snapshots, will you view them? I've had one MVP refuse to click on any outside link. I believe that if I show you diffe...more >>

If error occur while testing the database via DBCC Checkdb command like table corruption error so how can we solve this.... or if any one have faced any DBCC CheckDB error... Thanks ...more >>

Any website available from where I can learn about SQLServer with XML.... Thanks ...more >>

I am a Windows admin who knows how to administer SQL server, but I don't have any experience in creating a data interface so that regular users, who don't know anything about SQL commands, can manipulate the data. Any good books or suggestions? Basically I want to be able to create something ...more >>