Viewing 15 posts - 3,031 through 3,045 (of 3,366 total)
There are two things you are running a Distributed View so you have to follow the restrictions for those Views, then use the correct SET option in your View definition....
February 5, 2007 at 6:37 pm
If you are in 2000 and below the best T-SQL programming books are by Ken Henderson, try the link below for his guidelines about writing stored procs. I have also...
February 5, 2007 at 12:42 pm
I would say run the code in Profiler in both boxes and compare executing time and do the same thing with Management Studio/Query Analyzer and click on show execution cost...
February 2, 2007 at 3:37 pm
Oracle's Jim Melton ANSI SQL member and Java expert said the main mistake was the Object database creators refusing to do the Algebra so for the most part these databases...
February 1, 2007 at 5:14 pm
Thanks Steve for posting this it is a very sad day for Microsoft and those of us who love data. I am still dazed.
February 1, 2007 at 2:18 pm
(To say the network admin has to know the data is like saying a SQL Server DBA must understand how Active Directory replication works. While some DBAs might need to...
January 31, 2007 at 7:37 pm
You have written about it fine but Network Admin or Security Admin in charge of data so the questions is what do they know about data? actually nothing yes some choose to know...
January 31, 2007 at 4:25 pm
(That's because SQL Server 2005 intentionally breaks inheritance for the data files.)
The desires of the Windows file system team should not be imposed on people spending money to buy a...
January 31, 2007 at 3:43 pm
SQL Server is not ignoring anything the MDF and LDF belong to the data sub folder in SQL Server folder in programs so how is SQL Server breaking inheretance of...
January 31, 2007 at 2:53 pm
I understand what both of you are saying and I still don't agree because his devs only need DDL creator role and Trace ON to create their dev databases in...
January 31, 2007 at 12:24 pm
If he is running testing and dev databases Backup and Restore moves everything like the original database in a web application that is important because you are moving all the...
January 30, 2007 at 9:08 pm
OK let me put it this way these file permissions are not relevant to skilled System Admins because the Backup and Restore wizard moves databases created in where ever, whatever...
January 30, 2007 at 8:41 pm
What the previous poster is saying is if you have this account in SQL Server everything in SQL Server was installed using that account so you have to plan and...
January 30, 2007 at 7:10 pm
SQL Server is RDBMS(relational database management systems) so a SQL Server database is MDF(Microsoft data file), LDF(Log data file), Secondary data file and .bak all of the above are stored...
January 30, 2007 at 6:57 pm
It may be a configuration problem because it is not related to edition per the edition features comparision chart below. Hope this helps.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
January 30, 2007 at 5:21 pm
Viewing 15 posts - 3,031 through 3,045 (of 3,366 total)