Viewing 15 posts - 916 through 930 (of 1,079 total)
SELECT DISTINCT [Name]
FROM TableName
WHERE Fruit <> 'Apple'
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2010 at 10:32 pm
I would recommend Full on production, but read up on the different types and decide which suites your environment and needs best:
http://msdn.microsoft.com/en-us/library/aa173531(SQL.80).aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2010 at 10:24 pm
SSPI:
http://msdn.microsoft.com/en-us/library/aa380493(VS.85).aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2010 at 10:04 pm
Use SSPI in your web.config, and use an application role, where the ID & Pwd will be save and encrypted in SQL Server.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2010 at 12:00 am
Suggest you set your credentials in the data source and not the actual report.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 3, 2010 at 10:55 pm
these sp's, what is your naming convention? please tell it's not SP_yourspcustomnamehere?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 2, 2010 at 1:10 am
I agree Steve, and for some weird reason, when opening a post with garbled code and lines of results, erm.. it makes one want to look the other way.
Not because...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 2, 2010 at 1:08 am
Violation of PRIMARY KEY constraint 'PK__ClassInfo__7C8480AE'. Cannot insert duplicate key in object 'dbo.ClassInfo'.".
constraint is stopping the insert as a result of trying to create duplicate keys.
specify your process to copy...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 2, 2010 at 1:03 am
MS Press Books
BOL
and a lot of SSC reading.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 2, 2010 at 1:00 am
It's true, going virtual holds a lot op pro's but also cons.
Weigh up the options, and the money you are going to spend, versus your needs.
It can go both ways,...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 1, 2010 at 9:48 pm
I agree, take the current backup and rather restore it as the new name.
This will keep structure etc i place.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 26, 2010 at 12:54 am
You cant host 2 DB's with the same name in the same SQL instance, even if you have different filenames.
Each DB name has to be unique.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 26, 2010 at 12:48 am
Read up on Gail Shaw's blog, lots of info and help on all types of Indexes.
She's a ninja when it comes to Indexes.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 24, 2010 at 10:27 pm
Nice comparison with zipper and bad code, decisions etc.
I agree Tim, none of us are perfect, so in the event of a "not on purpose" mistake, or even if anything...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 24, 2010 at 10:26 pm
Agreed.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 23, 2010 at 10:55 pm
Viewing 15 posts - 916 through 930 (of 1,079 total)