All - need some help...have the above installed which is great but now I am told that the DB I am trying to run on SQL2005 requires ASP.NET 1.1 NOT ASP.NET 2.0 as the DB in question is not compatible with 2.0. I can see that people run 1.1 and 2.0 along side each other then select the appropri...more >>

I have a Windows 2003 Std. server with SQL 2000 Ent. + SP4. I have placed the /3gb & /PAE in the boot.ini and enable AWE in SQL to use 6GB of RAM however after I restart the PF goes straight to 4GB and SQL will only use between 10 - 40MB. If I disable AWE SQL can access up to 3GB. Why is this...more >>

How do I make use of the counter value returned by sys. dm_os_performance_counters...meaning, when I run this in Management Studio as an example, and I get the following returned: Object_Name = SQLServer:Databases Counter_Name = Transactions/sec Instance_Name = MyDB cntr_Value = 4230 Yet,...more >>

Is there any way to create a systemtable? I need to hide a table of my own from regular users. This table is not temporary. Kind regards, Costi Stan ...more >>

Hi, I have 2 data tables in an SQL database that normally have a new record inserted by calling 2 stored procedures from a vs.net web application. I would like to enter 1 row of new data for each table every evening (like running a dts package). There are a few complications though. The fir...more >>

I'm posting this question to a couple places since it crosses disciplines. I home someone out there can help me. Here's my dilemma. We have a SQL based Association Management System with customer information and we need to periodically update a Public Folder in our Exchange organization wi...more >>

I feel kinda funny asking this as I am not working on this project and cannot try ideas, but am a junior level/pre-DBA and would seriously like to learn. We are experiencing performance issues somewhere and I have two theories I would like to open to discussion. So if it is not a waste of you...more >>

I have .idx and .dat files. I need an ODBC driver to allow me to attach to or import these tables. Anyone have any clue how to help me? ...more >>

Hello I'm looking for a ready to use user function which takes a string as a argument and returns string containing fist letter of each word as capital. example: initail: sUN iS ShINIng result: Sun Is Shining The similar role in Oracle has function called INITCAP Best Regards Dar...more >>

Hi everyone, We are running a SQL Server 2000 instance which is getting hit with hundreds of queries a minute. The vast majority of these are very short-lived, low overhead queries. Some of them are highly resouce intensive (< 1%). My problem is that lately, our SQL Server CPU utilization has...more >>

I am having an issue with a dts package. I am able to execute the package as myself from enterprise manager but I recieve an error when running it as a scheduled job. I have read http://support.microsoft.com/kb/269074/en-us and am either missing something (highly likly) or it doesn't apply to m...more >>

I have sql2000 db that had two domain groups in the dbo role and one SQL acct also in the dbo role. There are only tables in the db and all owned by dbo, I am not sure if the developers created the tables and then changed the owner or specified on creation. I restored the db to sql2005sp1 an...more >>

I must be missing something but for the life of me, and outside editing the registry's FullTextDefaultPath I can not find how to set a SQL 2005 instance default Full Text Path. Isn't there a better way in 2005 to do this? I see all over the net that in 2000 you have to set the registry but i...more >>

Hi, can anyone provide me with a list of sample queries situations and queries for those situations .. for database like northwind ..pubs and other default dbs that come with sql .. it will act like learning ground for me .. specailly looking for joins stuff thanks .. can then .. please mail ...more >>

I have a fairly complex query which takes about 3-4 seconds. Since it uses quite some tables and views which I won't be able to post, I will just post my findings. This SPROC takes a long time to comlete often propting to kill the process. During such poor show the profiler records unsually hi...more >>

If create a stored procedure like this: create procedure dbo.usp_trxn_enum ( @a_trxn_type_cd char(2) = null , @a_allowed_mainframe_file_cd char(7) = null ) <snip other code> Is it executed like this: exec dbo.usp_trxn_enum 'XX', 'XXXXXXX' Thanks, -- Jerry ...more >>

I just acquire a new server with 8 hard drives and 2 RAID controllers. The objective is to load SQL SERVER 2005 on this server to run CRM and one other database centric application. In addition rerporting services and analysis services will also be installed. I have configured two of the RAID ...more >>

Hi Fellows! I am trying to establish a connection between SQL Server 2005 Server which is setup on Windows Server 2003 along with Visual Studio 2005. The problem is that when i try to connect it through management studio using <servername>/databasename method , i become successfull and got...more >>

Before I manually restart a server (e.g. usually after a MS critical update patch), what are the things I should do to make absolutely sure that some user does not randomly connect to SQL Server (like from a web application) during the restart, access a database, and potentially corrupt data or l...more >>

Hey, I need to script out all the jobs in SQL 2005. I know how to do it in SQL 2000 and don't find a way to do it in SQL 2005. I can do it one by one but that's too tedious. Please let me know how to do that. Thank you Tej...more >>

I am using Veritas Netbackup 6.0 and I am attempting a full backup a MSSQL 2000 database with a total size of about 1TB. The backup usually takes 12 - 18 hours and the multiple attempts at restoring this database have been unsuccessful. I have been unable to retore this at all and I am in des...more >>

Hi, My SQL Server is Running on Windws XP m.c with 1 GB of Memory. I want to know by default how much of memory will OS Consume and How much memory is availiblie to other Application?. can i change this settings?. Thanks and regards Praveen ...more >>

Hello there, I have a big problem and I hope you can help me. I have tried to use WSS 3.0 (SharePoint) beta, but I have a problem with the fulltext search of pdf files. I don't know whether there is a problem with the SQl Server or with the WSS Server. I am using the following System: - ...more >>

I have a database of SqlServer call myData, and it's physicial is c:\myData.mdf. Some one stop the SQLServer Service, then delete c:\myData.mdf, then start the SQLService, and then the database myData is dead. How can I detect if myData is in this state? ...more >>

Hi, I want to store following types of data in SQL server 2000 Text : This column captures text (mostly plain text, sometimes we have the ability to insert RTF format) Binary Object : A typical BLOB field. We can store ever...more >>