Search results for query: *

James - you are quite right - we have 4 servers here and some silly b*gger has left one as SQL7, even though all the clients have been upgraded to SQL2000. I tried the same function (the one from help) on the SQL2000 server and it worked fine (no dbo. or database name needed). Thanks for...

James - thanks for that. I tried doing it and it was set to 70. So tried to set it to 80 as you suggested and got the following: Server: Msg 15416, Level 16, State 1, Procedure sp_dbcmptlevel, Line 90 Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]] Valid values of database...

I am trying to write a User Defined Function in SQL Server 2000. Unfortunately my copy doesnt seem to want to support them. I have opened the on line help and pasted in the following example CREATE FUNCTION CubicVolume -- Input dimensions in centimeters. (@CubeLength decimal(4,1)...

Panic over - I found the answer myself by heavy use of google searching. Basically its all to do with the order in which you install the .NET framework and start IIS. I'm sure I wont be the only person to hit this major Microsoft b*lls up so you will need to got to : Microsoft Knowledge Base...

I am a new asp.net user and have just spent 3 days on a asp.net course. All worked fine there but I am now trying the same on my own PC and hit a wierd problem. If I add any of the new web form controls they are not being 'read' by my computer. Eg - I created a form - test.aspx and added a...

I am a new user and have just spent 3 days on a asp.net course. All worked fine there but I am now trying the same on my own PC and hit a wierd problem. If I add any of the new web form controls they are not being 'read' by my computer. Eg - I created a form - test.aspx and added a button...

Using the exec(@sql) syntax in a stored procedure increases its flexibility. It allows you to build up a select string based on parameters passed ( or obtained by prior sql queries) For a good ( if rather pointless, business wise) example you can pass the name of a specific field and table as...

In a nutshell Access is a combined Client & Server product -the client is the user interface (forms - reports etc) and the server is the sql database. Other similar products ( though older) include dbase and foxpro. SQL Server is similar to one half of this - the server. (though a much more...

I am currently designing a database and my client requires that as every change occurs on my main 'customer' table, a log in the way of all the fields from the customer table is created. Thus if the customer table changes 10 times in one year, I will have one current record on the live customer...

Take care using [if not exists]. My experience is this is incredibly slow on large tables.

I am having a problem using VB6 and Outlook under XP. The VB6 program was originally written and run succesfully under W2000 - it consists of a routine that auto-sends multiple emails to multiple recipients (based on the contents of a SQL table). Under XP this still works, but Outlook's new...