Click here to Skip to main content
Page 1 of 7
Page Size: 10 · 25 · 50


Author filtered by: RedDK [x]
Answer 14 May 2013   license: CPOL
Suppose the .mdf and .ldf are specifically the AdventureWorks2008R2:EXEC sp_attach_db @dbname = N'AdventureWorks2008R2', @filename1 = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\AdventureWorks2008R2_Data.mdf', @filename2 = N'C:\Program...
Re: Boiling eggs by RedDK
Forum Message 13 May 2013  
You mean from one of these? http://en.wikipedia.org/wiki/Chicken[^]
Forum Message 13 May 2013  
No one should be penalized for my sarcasm. Someone! Please help this man!
Forum Message 13 May 2013  
You work for codeproject. You should be able to see the server logs, right?
Forum Message 13 May 2013  
You'll also be able to add "I fixed that" and then, eventually, "I didn't pay a mechanic to do anything (nothing)".
Forum Message 10 May 2013  
So please reinstate. Need a select command for getting table column values into an xml attribu
Re: Hey!!! by RedDK
Forum Message 10 May 2013  
Hi Friday, Where are my fishheads?
Forum Message 9 May 2013  
Yes! Intestacy. That was the word by which I was being black-jacked!
Forum Message 9 May 2013  
This linked-to-site gives me the willies. It's this verticle banner of distractions that makes me squeeze down my browser to show only the article during a scroll. That weather site ... with the li
Forum Message 9 May 2013  
Yeah, that's it. Preliminaries. Think of the whole assembly as a linked list. Considering the CAR and the CDR at this point. Or as in medieval times the "taking of heads" paradigm.
Forum Message 8 May 2013  
Well, One could revive Tuesday's loaf by laying it out on the picnic table in a wet lunch bag, under noonday rays, if they were so inclined ...
Forum Message 8 May 2013  
Spring for Adobe Acrobat (9) Pro ... If you have the time you might find something useful to do with it. Fortuneately there's enough to fiddle with that you'll decide you don't need the half of it
Answer 6 May 2013   license: CPOL
Follow these steps:1) From Windows Start Menu find Administrative Tools and Start Task Scheduler.2) In the Action Pane select "Create Task". A five-tabbed dialog will open. Give the new task a Name and if inclined provide a Description. Security options are also available; tick if...
Answer 4 May 2013   license: CPOL
Here's something. Assuming the table [tablename] was made like this:--USE [cpqaAnswers]--GO--CREATE SCHEMA [cpqa]CREATE TABLE [cpqa].[tablename]( [row][nvarchar](76) )Do this:CREATE TABLE [cpqaAnswers].[cpqa].[tablenameIdx]( [theRowNumber][int]IDENTITY(1,1), ...
Answer 30 Apr 2013   license: CPOL
Store all sto proc code blocks/scripts/.sql/etc in tables in a database. Enable full-text search. Or not.
Answer 27 Apr 2013   license: CPOL
TABLE (TSQL)?:CREATE TABLE [cpqaAnswers].[cpqa].[tbl_BH_personPlus]( [person][nvarchar](27), [other][nvarchar](28) )SELECT (TSQL)?:SELECT [person], [other] FROM [cpqaAnswers].[cpqa].[tbl_BH_personPlus]BULK INSERT (TSQL)?:BULK INSERT...
Forum Message 26 Apr 2013  
Strictly from the database side of the equation I'd vouch for the use of xml stored in the database as xml almost solely on the ease of using one table to stack all the individual "xml" up. It's sort
Forum Message 26 Apr 2013  
Who cares? Not that I'm a electronics engineer hell bent on inventing the next great RAM device ... Whatever works right now. Incidently, you might look at things like this. Photoshop 64-bit wil
Forum Message 26 Apr 2013  
Don't know your OS, so .... But two things, one addressed by FM, the first "feature" has to be enabled. Check to see if you've got any "Internet Information Service"- type icons in the treeview list o
Answer 24 Apr 2013   license: CPOL
How does one add an index easily to a table that already exists?USE[cpqaAnswers]GO CREATE TABLE [cpqa].[tbl_BC_EasyIdx]( [Idx][int]IDENTITY(1,1), [PeriodNo][nvarchar](15), [StartTime][nvarchar](77), [EndTime][nvarchar](32) ...
Answer 23 Apr 2013   license: CPOL
Let's work through it. There's some good.declare @PNO varchar(50)set @PNO ='GP90' PRINT @PNOThat's good; get "GP90" as a printable string in the message window.--update PurSettings -- (means nothing to me yet)declare @GPValue [nvarchar](MAX) -- not even slight...
SQL
Answer 23 Apr 2013   license: CPOL
There is an article here on this site:Search term, cp Article(tick) on "spatial geo"[^]
Forum Message 22 Apr 2013  
Augsburrrrrrrrg ittttt issssss ........
Forum Message 22 Apr 2013  
That's like trying to ... wait I can't say that in the CP lounge can I?
Forum Message 21 Apr 2013  
_yyeehaw! try: http://msdn.microsoft.com/en-us/library/ff878119.aspx[
Forum Message 21 Apr 2013  
I've used McAfee on Windows Server 2008 R2 ... for five plus years. That's two (complete?) turns of McAfee "development" cycle and although each time they've changed something in their final productio
Forum Message 20 Apr 2013  
uhm, youse might type in da words "his beaver down". Use Google!
Forum Message 20 Apr 2013  
What's this "\o/" ... "with his beaver up"?
Forum Message 19 Apr 2013  
Open any downloaded internet black & white image of personal interest using Photoshop, activate the smudge tool and, using your mouse make swirling motions through the picture. Increase the rate at wh
Forum Message 19 Apr 2013  
Proverbs 6:6
Answer 18 Apr 2013   license: CPOL
If this "(D:" is not a typo and is indeed what was executed then that error return is correct:ALTER ASSEMBLY ClassLibrary5 FROM (D:\RMS\visualstudio\Projects\ClassLibrary5\ClassLibrary5\bin\Debug\ClassLibrary5.dll' WITH PERMISSION_SET = EXTERNAL_ACCESSDoes this work:ALTER...
Answer 18 Apr 2013   license: CPOL
password:"If a password is defined for the backup set, the password must be supplied to perform any SQL Server restore operation from the backup set. A backup set password does not protect the backup file from being overwritten, however. To prevent a backup file from being overwritten, use a...
Answer 17 Apr 2013   license: CPOL
I think you're after a group of related TSQL statements, all of which summarily perform the above desired work:USE [cpqaAnswers]IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[cpqa].[tbl_ID_ProcessDCI]') AND type in (N'U'))DROP TABLE...
Forum Message 16 Apr 2013  
Start here: www.nasa.gov Search on: data, download Doubly seriously, JPL has MANY tiny applets that often have data output options. I mean you did say "astrogation". You're committed to the w
Forum Message 15 Apr 2013  
Hi CM, IE v. 8.0.7601.17514 32-bit (on 64-bit WS2k8R2) Yes/yes(no). The sign-in disappears BUT is touchy. And by that I mean using ALT I can activate it's second-clickedness.That second click i
Re: DO'H!!! by RedDK
Forum Message 14 Apr 2013  
There isn't any "About" in the Help menu so there's no way to tell what the version is from there. The console says 2012 so I'll assume it's fairly new. Until I hit the ClearType snag I was all set
Re: DO'H!!! by RedDK
Forum Message 14 Apr 2013  
PowerShell ... as in PowerShell ISE? If ISE, what happens to you when you choose "Tools/Options" and wait for a couple of seconds? Do you get "Error X An unexpected error has occurred, and Windo
Forum Message 14 Apr 2013  
At last a comparison! Please recall a comment I made here in bugs&sugs about the workaround I had come up with in order to sign into this website; if I myself can recall it .. it went "It's ok, I've g
Forum Message 14 Apr 2013  
oo oo, an answer! Note that the above was merely a post-hypnotic suggestion and no reply was necessary.
Forum Message 14 Apr 2013  
"Now why didn't they tell me about this in school?" Because you were too busy earning your degree in something other than Computer Science?
Answer 13 Apr 2013   license: CPOL
Information about "Windows Services" follows:01. Open "Computer Management" console.02. In the treeview find "Services"03. Tab "Standard", sort by "Name"04. Highlight anything in the window, keyboard press "S"05. See (all) the "SQL Server (your instancename here)"06. Right click...
Forum Message 11 Apr 2013  
I liken it to feature creep. Take, for example, today's advertisements on the T.V. for the latest model big-name auto manufacturer ... ask yourself this question: "Didn't I used to pay in dollar
Forum Message 4 Apr 2013  
Vrai cool, Now if I could only use a trick like this to get all 106 pages of my reputation history I'd be a happy camper! But lounge history to the top of my desk off into my lap is cool as I sa
Re: Math puzzle by RedDK
Forum Message 3 Apr 2013  
Yeah, You'd want a kind of Voronoi algorithm runninng to get that bubble optimized. Or else all the ornaments would be clinking against each other and possibly breaking into shards and falling
Question 3 Apr 2013   license: CPOL
Sounds easy enough ...EXECUTE sys.sp_catalogs 'server\instance'returns: CATALOG_NAME DESCRIPTION ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ x ...
Forum Message 3 Apr 2013  
Waiting for another book to arrive ... The Brothers Karamozov. Wherein it's rumoured someone eats a glass after consuming the ambrosia once within.
Re: Math puzzle by RedDK
Forum Message 3 Apr 2013  
Seems to me you would adjust the radius in each of the psychircular entities one see's in this illustration ... frinstance: http:/
Answer 3 Apr 2013   license: CPOL
USE [userdatabase]GOSELECT [idx],[col01],[col02],[col03] FROM [userdatabase].[example].[usertable] ORDER BY [idx]
Forum Message 31 Mar 2013  
Aber Herr Docktor Professor Pangloss!

Page 1 of 7
1 2 3 4 5 6 7


Advertise | Privacy | Mobile
Web04 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid