Database

softdev_sup wrote: i will also use Sql server if i am in Microsoft env. and tools while will def. go for mysql in case of php and linux/unix platform I think that that is the right way to think about it too. :) Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

Aw, my aplogies, there's no need to create a linked server. You can just prefix the entities that you need to denote the database; SELECT * FROM [database].[schema].[table] E.g.; SELECT * FROM Northwind.dbo.Employees I are Troll :)

:thumbsup: Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it

Yes, I noticed already. Lame mistake :sigh: Fratelli

look out for slash it should be \ not / Data Source=DREDDY9/SQLEXPRESS; Data Source=DREDDY9**\**SQLEXPRESS; :doh: Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it

This is the most common problem when Database server couldnt be reached. :) Check if you made firewall exemption to the SQL Server browser Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

Hulicat wrote: How do I generate the GUIDS (unique identifers) from a DTSX package? ExecuteSql task with a call to NEWID() Script Task with a call to new Guid() take your pick.

Thanks Johan, There's some good points in there. Like you say, the company is divided by sites for a reason, and yes large parts of the data is specifically for an individual site. I'm going to take a look at each table and decide how up to date it needs to be with respect to each site. Thanks for the suggestions. Simon

You do not say which SQL Server you are using reading about, but I suspect that it is MySql, since that is the only one that I know of that has a selection of storage engines. If this is correct, basically the different storage engines available are better suited to different types of application/data. You might be better off visiting the MySql site, specifically this page[^] as a starting point. Then just follow your nose. :) [Edit] 1) fixed bad wording in first sentence. 2) Here is a link to stuff about the Storage Engine for SqlServer 2005. clickety[^] [/Edit] Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” modified on Friday, September 11, 2009 6:53 AM

Or: SELECT * FROM TEST_TABLE WHERE STARTTIME IN (SELECT MAX(STARTTIME) FROM TEST_TABLE GROUP BY NICKNAME, JOBNAME) My advice is free, and you may get what you paid for. modified on Friday, September 11, 2009 8:04 AM

By using a varchar datatype for the insert parameter. It seems there is an implicit conversion from varchar to hierarchyid in SQL Server 2008 oParam = new SqlParameter(); oParam.ParameterName = "@NodeKey"; oParam.DbType.Equals(SqlDbType.VarChar); oParam.Value = this.NodeKey.ToString(); oCmd.Parameters.Add(oParam);

select * from yourtablename where DateDiff(year, myDate, getdate()) >= 3

I think this might be the cause of Unclosed connections. Always use using block and also Before you leaving the block use connection.close(). ;) And hey, you are using SQL Server Express 2005 in production environment.. :omg: This is weird. You need to keep in mind of the limitation of 4 GB Database size and 1 GB of RAM Usage. :sigh: There is as such no limitation of Concurrent Connection, but if you go on creating connections, it will soon run out of resources. Also you cant include 2 -4 GB ram because of Limitations. :( Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

Maybe... I did it with SQL2005 before posting... don't have SQL2008 here... I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!

Ashfield wrote: In reality, the guy wanted to know the answer to an interview/exam question It definitely feels like a theory question that has no basis in reality. I would have trouble answering D as I know I don't know everything and I hate having to answer that to irate users, so I would be looking for the E option - more research required.

You're right, I never use sp_execute, just execute(sql). What was wrong with his proc then? Never underestimate the power of human stupidity RAH

mighty mojo you have. :) Luc Pattyn Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.

I may be wrong but can't you simply type in the domain/username when setting up a user. I know you would normally chase through the lists but I think you can also just type it in. Never underestimate the power of human stupidity RAH