Viewing 15 posts - 4,141 through 4,155 (of 13,469 total)
it looks to me that on my 2012 DVD, you could simply grab the 58 meg MSI found here:
{YourDrive} X:\x64\Setup\sql_ssms.msi, right?
January 16, 2013 at 10:06 am
ok my memory is solid, even if my confidence in it is not:
Important : You might have noticed that I've not mentioned transaction log backups or log chains at all....
January 16, 2013 at 10:01 am
Gazareth (1/16/2013)
Ha, beat me to it 🙂
lol fast fingers today my friend,, but am i correct about a full backup not breaking the log chain?
January 16, 2013 at 9:57 am
As I understand it, a full backup will never break the log chain .
for me, i just do a backup with copy only for these situations.
BACKUP DATABASE [SandBox] TO ...
January 16, 2013 at 9:55 am
cummings.rd (1/16/2013)
The DB I restored is 8.25 MB; I use SQL management studio 2008, I set the options for the restore as follows...
Overwrite existing database WITH REPLACE
Leave db ready...
January 16, 2013 at 9:32 am
similar to A word document, you can set up a template with something that represents the items that would be substituted.
then you need a cursor/loop for each email you plan...
January 16, 2013 at 6:30 am
Koen Verbeeck (1/15/2013)
That's great stuff Lowell, I didn't know you could force the installation of the provider.
Thanks Koen!
I've bean my head against that 64 bit installation rock a few times,...
January 15, 2013 at 2:49 pm
Krasavita (1/15/2013)
Thank you,How you move the table into a separate filegroup?
peek at the code i posted, which creates a new table in the filegroup.
for an existing table, you can Use...
January 15, 2013 at 2:35 pm
I've been in on a few other ACE /EXCEl threads, and have my comments saved from when i thouroughly tested this and got it to work:
myself(Lowell)
install...
January 15, 2013 at 2:29 pm
Want a cool sig is correct. what was produced is valid XML, just not prettified for readability.
SQL2000 used to have trace flag 257, which would format the xml with extra...
January 15, 2013 at 12:32 pm
here's something i put together for a different post that was talking about setting a table to read only:
this is not copy/paste/execute code, but rather, amodel to use to modify...
January 15, 2013 at 11:11 am
ok i'm not sure if this is doing a valid performance test or not;
i had initially thought that creating an object would be slower than regex, but that's not what...
January 15, 2013 at 10:54 am
it depends;
you cannot create an extended property that points to an object(includes the parameters for level0type/@level1type/@level2type) without the object actually existing.
an example:
EXEC sys.sp_addextendedproperty
@name=N'ColumnDescription',
@value=N'Credit...
January 15, 2013 at 8:21 am
cummings.rd (1/14/2013)
January 14, 2013 at 2:35 pm
i'm guessing that the application does not expect an empty database...it expects a database with specific tables, procedures, views etc to exist, but probably many of those objects are allowed...
January 14, 2013 at 2:18 pm
Viewing 15 posts - 4,141 through 4,155 (of 13,469 total)