Hmm?? I will look that over. If I have specific questions, I'll post back here. Thanks. Matthew Moran The IT Career Builder's Toolkit...
That is what I thought. Okay, I have a crazy idea... I can get to both sql server's from either site - via my ado connection in asp or .net. The...
I cannot connect to the database via Enterprise Manager. The hosting company has a web based manager - they don't allow direct connectivity. Their...
I have a sql database - hosted for a small online application. My only interface into the table - for design and administration of the data - is...
Thanks. Exactly what I needed. Matt
Okay, the last challenge was simple and worked wonderfully. Here is one that seems slightly more complicated. I have a view that shows me the date...
I realize this must be very simple but... What is the simplest and most efficient way of converting a field that has both date and time to the...
I have, what I hope, is a very simple question.. I want to be able to query a SQL DB and output using the "for XML auto, ELEMENTS" clause and bring...
Got it! Did a detach, copied the files, and reattached at the new server. However, I know you can do a live backup/copy to a new server. How do I...
I need to be able to copy the exact DB table structure (indexes, key fields, default values) between two servers. What is my simplest way to do...
The challenge is that I need to track the individual item seriel numbers. Each item relates to an itemmaster but then each item is also uniquely...
I have to build a system for a company that will items they sell, orders, and inventory. I have a broad question on tracking the inventory. I...
Thanks. I remember that method being covered. I was trying to get away from having the 8 stored procedures I've developed doing the same thing....
Hello all. I am back on my stored procedure question(s)... I have record locking properly and have you (Twan in particular) to thank. I had been...
I'm not sure where I would post this so I will start here. I have a database that tracks calls made to customers during the day. Each call...
I have been reading up on log shipping, backup/restore, etc. Thanks for everyone's help on this. Actually, it is both a one-time thing (I am going...
But do you realize that my database is in production? The database is, to the best of my knowledge, backed up by corporate every evening. However,...
The same user is the owner for each database. There will be no users in the 2nd database (where I am copying too) as it is just a playground for me....
I want to make a backup/restore of an existing database - back onto the same server with a different name - same user, same key fields, same identity...
I want to import the tables, views, and stored procedures from one database to another on the same server. There are about 60 users in the database...
Separate names with a comma.
