Viewing 15 posts - 11,746 through 11,760 (of 18,923 total)
Sorry for the confusion. I was reffering to the select that was giving the headaches to the greener guys... so that's why I don't include the pin table in...
September 19, 2006 at 4:35 am
I usually don't include the pin table part in that function... It already gives enough head aches as is
.
For those interested look...
September 18, 2006 at 10:35 pm
I don't have time to answer your question in detail... but this should do the trick
.
September 18, 2006 at 12:19 pm
Function split - set based static sql :
--Start generating objects
IF Object_id('fnSplit_Set') > 0
DROP FUNCTION dbo.fnSplit_Set
GO
IF Object_id('Numbers') > 0
DROP TABLE dbo.Numbers
GO
CREATE TABLE dbo.Numbers (PkNumber int identity(1,1), dude bit...
September 18, 2006 at 12:16 pm
Can you make a linked server from the production database to the msde instance?
If you can't :
Make a select into statement that extracts the valid data to a new...
September 18, 2006 at 12:12 pm
How do you need to transfer the data??
Everything gets transfered?
Only new data gets added?
Data must be inserted and updated but not deleted?
September 18, 2006 at 12:00 pm
I once uninstalled sql server 2005... took me 2-3 tries because there were still some componants installed... Maybe you have a similar problem!
September 18, 2006 at 10:54 am
I would be extremely surprised to find out that the system did this on its own... it's not like it does a search and replace on your hd and start...
September 18, 2006 at 10:51 am
Ask them to clarify what they need, then we'll be able to guide you on this... and do it only once
.
Make sure...
September 18, 2006 at 10:36 am
I am not very familiar with those system functions.
Do they want you to run those like every day and keep the results in a history table and have that available for...
September 18, 2006 at 9:57 am
What do you need to audit exactly???
Data modifications, data access, historical data??
September 18, 2006 at 9:41 am
Depends what you plan to do with 'em in the proc.
Can you show us what you need with those parameters?
September 18, 2006 at 8:38 am
Great. I'm still opened to other suggestions since I ain't no expert in the matter.
September 18, 2006 at 8:36 am
Quick and dirty :
Select * INTO dbo.Table2 from dbo.table1 where 1 = 0
That will copy the columns only, you won't have any dri, constraints, defaults, indexes or keys.
September 18, 2006 at 8:06 am
What error message are you getting?
What type of connection are you trying to make to the server (windows authentication or sql server)?
Is the server set to windows authentication or sql...
September 18, 2006 at 8:05 am
Viewing 15 posts - 11,746 through 11,760 (of 18,923 total)