Perhaps this has already been answered. If so, I apologize. I'm a newbie at this stuff. I have a DTS package to import some Visual Foxpro data. Yes, I said Visual Foxpro. :) The DTS package works beautifully when I rightclick on the package and choose "execute." And it works beautifully w...more >>

Hi, I'm semi-new to crystal reports & sql server and what i want is to extract data from a sql server file. I've been able to connect to sql server directly and get the info. i need but is there a way to just open the data file (in crystal reports) without making a server connection? ...more >>

Hello All, I am currently creating a browser interface for our thick client which was built on Visual Basic using COM ( a three tier environment). We support environments where the SQL database server is separate from the application server. The problem I am facing is this. When I ...more >>

I currently have 2 tables as follows: CREATE TABLE [CRPDTA].[F55MRKT119] ( mhan8 int, mhac02 varchar(5), mhmot varchar(5), mhupmj int ) GO CREATE TABLE [CRPDTA].[F55MRKT11] ( mdan8 int, mdac02 varchar(5), mdmot varchar(5), mdmail int, mdmag int, mdupmj int ) What I would li...more >>

I hosed myself, please help me somebody. We have a development server (SQL7) where the database is a restored copy of production (where we use replication, but not in the development environment). While we rebuild the server recently (so we could move off of NT onto 2000), everything loo...more >>

Hi NG! I wrote a stored procedure which at first deletes 100.000 rows and then inserts 100.000 new rows. There is a huge difference between executing this SP in the query-analyzer (runtime approx. 2 minutes), and scheduling this SP as an Job (runtime > 30 minutes!!!). Why? Whats the i...more >>

I have a 1:1 relationship between tables and am finding that the parent is sometimes mising the child. How do I query for what is not there? TIA ...more >>

I know that a query inside a called UDF does not show up when displaying the estimated query plan, but are the resources (CPU, DiskIO) used by a UDF that is call from within an SProc or embedded in a SQL statement included in sp_who2 and Profiler BatchCompleted? Also how performance drainin...more >>

I have a problem (who not?) with a function which i'm using in a view. This function is a function which calculates a integer value of a date. For example: '12/31/2004 00:00:00" becomes 20041231. This is very handy in a datawarehouse and performes superfast. But here is my problem. My calenda...more >>

Is there any method by which i can get the list of all sql server users? ...more >>

I have taken over a transactional replication setup that is being used for fault tolerance (I know, I know...). The scenario I am concerned with is where the publisher goes down due to failure, so we need to point our application at the subscriber and start updating the data there. We are not...more >>

I'm getting Not associated with a trusted SQL Server connection errors on a .Net windows service I wrote, when it's running on my application server. It's not a problem with mixed mode security. I'm set for mixed mode and I've been running the service on the app server for over a month with ...more >>

Hi, I'm converting an Access 2000 database to Sql Server and must be missing something obvious. Using the Import utility in Sql Server, the Access queries seem to get executed and the resultant data imported as tables. Oops! Using the Upsize lizard in Access 2003, the queries aren't even ...more >>

Hi All, Can anyone recommend any blogs that should be read on a regular basis? Thanks Michael...more >>

Could not initialize GWUTIL.DLL ...more >>

Using SQL2000, I have a DTS that takes data from MySQL to sqlserver, the catch is I want to specify a specific range of dates. How to use a global variable? At the moment I manually changes the dates and jobs run on a daily basis. sample sql statement from Mysql connection: select * from T...more >>