Programming SQL

SqlFileStream Fails
Using SQL Server Express 2008 SP1 on Windows XP SP3. Unplugged network cable connection. When creating the SqlFileStream class an exception is thrown "The network connection cannot be reached." This works when the network cable connection is plugged back in. Does anyone know how SqlFileStream can be made to w... 23 Mar 2010 11:20

remote call of sys.object_definition()
Hi guys. I am trying to compare the db objects on our new 2008 server with those on the 2005 server. we have the 2005 server set up as a linked server using NT authentication. here is my query to get all of the objects which don't match [code] with bfld2008 as ( select o.object_ID,coalesce(OBJECT_DEFINITIO... 22 Mar 2010 09:24

Hierarchy Question (sort of long)
I understand hierarchies, but I have a problem that maybe someone can help me with. I have to be able to represent "special false levels" within a hierarchical representation. What I mean is this: Level 1 Boss ... 19 Mar 2010 12:02

Invalid Column Name
Need help. Msg 207, Level 16, State 3, Procedure PROC_CLN_DATA, Invalid Column Name , Line nn Received the above error when I execute the following Thanks. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO --drop proc PROC_CLN_DATA ALTER PROCEDURE PROC_CLN_... 19 Mar 2010 08:12

Server: Msg 207, Level 16, State 3, Procedure PROC_CLN_DATA, Line
Need help. Received the above error when I execute the following Thanks. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO --drop proc PROC_CLN_DATA ALTER PROCEDURE PROC_CLN_DATA AS ... 19 Mar 2010 04:55

Connect to SQL Express 2008 on local machine
Hi all, I am trying to link an Access Database to a SQLExpress 2008 database on my own machine. I can create a DSN that can see, and link to, the System databases (using Windows Authentication), but it can't see / connect to the database that I have created. Do I have to give myself specific permissions to my new d... 22 Mar 2010 06:05

Calculate in SELECT
How do I get: SELECT ((127/153)*100) AS percentage to return 83 (or so)? Regards /Morten ... 19 Mar 2010 00:35

Like Operator with Wildcard
I'm using SQL2008. I'm searching postal addresses ,which I realize is a rather difficult and obtuse task, but anyway... Is there a way to search in TSQL using the "Like" operator that includes a wildcard, in my case, a period? For instance, I'm searching for all addresses that end in "Ave" (for Avenue). But... 18 Mar 2010 21:15

Weekending - grouping by the week
Hi using sql2005, I would like to return summary statistics that are grouped by weekending date (Friday) between date range start and end parameters. Any ideas or suggestions appreciated :-) Many thanks, Jonathan ... 18 Mar 2010 00:31

Adding Statistics
I ran the Engine Tuning on my Tuning trace for a page that is a little slow. It seemed that indexes were fine but was still a bit slow. The Recommenations are only to create statistics, 2 on one table and 7 on another table. When I put my mouse over the Target of Recomendation, I get something like: *****... 17 Mar 2010 22:19