TSQL -insert script in MSQL database

Thank you very much for your useful help I need to import in my SQL database external data from acc…

Need to copy structure but not contents

I need to copy most tables, stored procedure, and views from one very big production system to a sm…

mulitple nic cards

We have two servers, one an application server and one a database server with sql server7 /NT4. The…

SQL server administration

Any body can guide me on topics i need to concentrate on sql admin.

Point in Time Restore

Has anybody used "point-in-time' restore. I have tried through EM, but everytime I attempt it the c…

Createing a Stored Proc from a Stored Proc

(SQL 2000 SP1) Basically I have been asked to find a way to create a new stored procedure in a diff…

Generation at the 'Subscriber'

I'm trying to create a push merge subscription at my webserver. The SQL instance is called SERVER01…

Loading MDF/LDF files

Hi, I need to recover data from MDF/LDF files, is this: 1. possible to do 2. how is it done, do I n…

Scheduling Batch Cmd from SQLAgent

Mornin' all, I've been trying to use the SQLAgent to run a batch command on the server but nothing …

SQL and RAM requirements

Hi I know there are no hard and fast rules to how memory a server should have - but how does one de…

Dynamic SQL, SPs, Views and mixing it all up

Hey folks, here is a situation I have visited probably once every 6 months over the last several ye…

Security Alert : SQL Server Worm Virus Attacking Systems

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/colum…

Referencing objects as dbo.