Viewing 15 posts - 8,716 through 8,730 (of 9,244 total)
what is your MDAC version
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2008 at 5:46 am
to make the trace easier to read\sort dump the output to a sql table
SELECT * INTO tablename
FROM ::fn_trace_gettable('d:\path to trace\tracename.trc', default)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 25, 2008 at 3:29 pm
the compound key has to be unique, you can have the same value in single columns as long as the combined values are unique
col1 ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2008 at 3:25 pm
Jeff Moden (11/22/2008)
Heh... sorry, Perry... bit of an inside joke. I'll explain it sometime, but not here.
Jeff, send it over PM
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2008 at 10:54 am
begs the question, if you find yourself having to store the same data in a column should it really be a primary key??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2008 at 10:51 am
GilaMonster (11/23/2008)
don't slice a LUN and give it to the data files and slice another from the same disks and give it to the log files
this is very important, if...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2008 at 10:44 am
i'll send you my resume which contains my name, address, date of birth ,etc. I dont think so
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2008 at 5:54 am
anupamabr (11/13/2008)
I am new to Sql
I created asp.net web project.I need to connect this website to my locally installed database
.For that I need to modify the connection string of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 23, 2008 at 4:09 am
samalex (11/21/2008)
In our maintenance plan for each database, we're doing a nightly full backup, but I've noticed this isn't truncating the transaction logs. I thought this was how it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 23, 2008 at 3:50 am
if you have removed builtin admins group i would add that back first before switching domain memberships then remove when finished. If all the logins are SQL and you're not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 23, 2008 at 3:44 am
manually install the sql client first by using the msi package
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 23, 2008 at 3:41 am
UDBNT (11/20/2008)
others are all Simple.
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 23, 2008 at 3:33 am
it can backup log during database backup but cannot truncate the log file
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 23, 2008 at 3:32 am
have you tried contacting Quest support?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 23, 2008 at 3:25 am
are you using T-SQL or SSMS gui?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 23, 2008 at 3:24 am
Viewing 15 posts - 8,716 through 8,730 (of 9,244 total)