Recent content by danb

They're Fasthosts. Need I say more? They actually told us that they could attach MS SQL databases when we asked them specifically prior to signing-up. Now we're going to have to move, which is very very frustrating. All their support people keep telling me over and over is that I can migrate...

Hi, I have a MS SQL database on a shared host, and would like to move it to a new shared server host. When moving, the database should remain exactly the same, without re-indexing of primary keys etc. The trouble is, my new host will not attach a SQL Server database, and are unwilling to...

No, that's what is required.

Perfect, that's just what I was looking for, thanks!

Hi, I've got a news table in an Access database, with the following fields/datatypes: ===== tblNews ===== news_id (auto number) news_headline (text field) news_article (memo field) news_date (date field) I have a select statement from an ASP page like so: SELECT * FROM tblNews ORDER BY...

Hi, The following code works in Firefox, but in IE7 it just spits out a screen full of weird characters: <% Response.ContentType = "application/pdf" FPath = server.mappath("pdf/portfolio.pdf") Response.AddHeader "Content-Disposition","attachment; filename=" & FPath Set...

I've just installed 'Microsoft Server Management Studio' (a free application) which seems to be able to connect to my SQL Server 2000 databases. I'm not sure how it works though yet, since it's quite different from Enterprise Manager. So far I can't see any GUI to create tables etc. Sure it...

Hi, I work on several SQL Server 2000 databases and usually do so with Enterprise Manager. However, since I installed Visual Web Developer Express (to help me move from 'classic' ASP development to .NET development) my version of Enterprise Manager will no longer work. I got Enterprise...

Hi, I've got the following MS SQL tables: tblProduct ---------- Product_Id | Product_ManufacturerCode tblProductDetail --------------- ProductDetail_Id | ProductDetail_ManufacturerCode | ProductDetail_CategoryId tblCategory ----------- Category_Id | Category_Name tblProductDetail is a...

Hi, I've got the following MS SQL tables: tblProduct ---------- Product_Id | Product_ManufacturerCode tblProductDetail --------------- ProductDetail_Id | ProductDetail_ManufacturerCode | ProductDetail_CategoryId tblCategory ----------- Category_Id | Category_Name tblProductDetail is a...

Server: Msg 15247, Level 16, State 1, Procedure sp_addsrvrolemember, Line 32 User does not have permission to perform this action. It's a bulk insert permission I think. I'm on a shared SQL server, so I'm having trouble allowing permissions.

Hi, I'm trying to run a procedure which does a bulk insert, but am getting a permissions error. As a total novice to SQL Server, could someone explain how to allow myself permission to do this? Thanks!

Okay, it's just occured to me to that script 2 creates a stored procedure, which I then have to run for it to take effect (sorry I'm new to MS SQL).

Hi, I'm using a thrid-party data provider to supply me with technical product specs for my e-commerce website. They have provided me with three very lengthy SQL scripts and several large (up to 30Mb) text files. When I run the first script it creates a bunch of tables. This executes...

Okay, I've refreshed the table pane view and there they are! Oops, didn't realise it needed to be manually refreshed. All sorted!