Viewing 15 posts - 1 through 15 (of 19 total)
Hope you get well soon Ken. We miss you in the twitters.
July 7, 2020 at 1:02 pm
Could also be a permissions issue. Does the account running the SQL Server Service have access to that folder?
May 17, 2013 at 9:34 am
Is the Server 64bit? I haven't tried it in a while, but I know when SSIS first came out you couldn't export to Excel on a 64bit install.
September 9, 2011 at 2:48 pm
Shawn Melton (12/16/2010)
Also, are you just taking all the MCTS first? If you take 70-450 next you will have the MCITP DBA for SQL 2008, 433 is the development test?
I'm...
December 16, 2010 at 9:06 am
da-zero (12/16/2010)
Congratulations!I passed the exam today.
Well then, Congratulations back at ya.
December 16, 2010 at 7:13 am
I have an instance of Express Edition and Express Edition with Advanced Services installed and both have the Storage folder. So that isn't it. I would try reinstalling. You also...
December 9, 2010 at 2:36 pm
Add one more for using a hybrid. We us Maintenance plans on our 10 SQL 2005 databases and we have custom scripts for the index maintenance.
December 9, 2010 at 2:17 pm
The ORDER BY has to come after the WHERE. Also there is already a where clause so you'll want to just add to that.
SELECT customerid,
firstname,
lastname,
SUBSTRING(phone_numbers, n, CHARINDEX(' ', phone_numbers +...
December 9, 2010 at 2:04 pm
da-zero (11/22/2010)
Congratulations!And thanks for the references.
+1
December 2, 2010 at 3:15 pm
This probably isn't it, but what is the size of the database and/or log file? Is it growing the files every time you run this insert?
November 24, 2010 at 1:17 pm
When you run dynamic sql, it runs in it's own scope. I don't think you'll be able to use the table variable, but a temp table should work.
create table...
November 23, 2010 at 2:34 pm
Adiga (11/19/2010)
This should work.
EXEC master.dbo.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', N'DatabaseMailProfile', N'REG_SZ', N'MailProfileName'
Excellent! I may still look at Powershell to do something with this as I have to loop through all of the...
November 19, 2010 at 1:39 pm
So I guess I should have looked a little longer before posting. I have figured out how to add the Operator (sp_add_operator), but i am still looking for the TSQL...
November 19, 2010 at 9:55 am
Coming form more of a development background I enjoyed seeing a basic article on why SHRINK is bad. A quick Google search will show you that it is considered bad...
November 9, 2010 at 9:35 am
I think there are two conversations going on here. The first being "Is it OK to treat people unfairly based on gender?" and I think everyone here has shown they...
October 12, 2010 at 1:30 pm
Viewing 15 posts - 1 through 15 (of 19 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy