Viewing 15 posts - 17,176 through 17,190 (of 26,489 total)
lmu92 (1/28/2010)
@Lynn: you might want to prepare your tent to hold a bunch of people arriving shortly... 😉Can we just stop by or do we need to show an invitation?
The...
January 28, 2010 at 9:32 am
Rubberized crystal?? Must be, it keeps bouncing around the world! 😛
January 28, 2010 at 9:25 am
Use the Import/Export wizard to create a SSIS package to move the data from selected tables to another database.
January 28, 2010 at 9:24 am
Krasavita (1/28/2010)
RESPECT PEOPLE
shhh. you really don't need to yell.
January 28, 2010 at 9:16 am
Oh, and trust me, I feel your pain in a way. We are now storing images and attachments for job applicants in our database. It has resulted in...
January 28, 2010 at 9:12 am
Are these 1 or 3 tables updated on a regular basis? If so, you need to back them up as well to keep your database transactionally consistant.
January 28, 2010 at 9:09 am
mw112009 (1/28/2010)
Yes the BACKUP commandOr if there is another tool or way let me know as well.
Either way is fine.
The only way you can do that is to "copy" the...
January 28, 2010 at 8:42 am
Oh ... No ... Halo tarnishing and slipping!
January 28, 2010 at 8:40 am
mw112009 (1/28/2010)
Is there a way in SQL sever 2005 to create a back up using a set of tables ( but not all of them )?
Do you mean using...
January 28, 2010 at 8:37 am
Krasavita (1/28/2010)
I read the books, you have so much time on you,so lucky
Actually, I don't have a lot of time. I have my own paying job that I also...
January 28, 2010 at 8:34 am
Krasavita (1/28/2010)
January 28, 2010 at 8:28 am
Then you really should consider using stored procedures to encapsulate standard queries that users then pass parameters to to restrict the data returned.
You really don't want to have ad hoc...
January 28, 2010 at 8:21 am
I'll be honest, I tried to read it, but it is so run together and disjoint I'm not even sure what your problem is. I agree with Gail, start...
January 28, 2010 at 7:54 am
GSquared (1/28/2010)
Lynn Pettis (1/28/2010)
In addition, the general users shouldn't even have QA/SSMS. The only people that should probably have these tools are DBA/Developers.
It might be difficult to block them...
January 28, 2010 at 7:39 am
You are aware that SQL Server 2005/2008 Express edition have restriction on the size of the database, 4GB. If each row is approximately 8K, I think I see why...
January 28, 2010 at 7:33 am
Viewing 15 posts - 17,176 through 17,190 (of 26,489 total)