Topics
Started by
Posts
Last post
I am struggling with the practice exercise 'Use SQLXML to Query the UniversalLog Table', that is in…
1 replies
Im new to sql server and practicing using it on a home lab. I'm trying to drop a clustered index fo…
2 replies
I am hoping that someone can help. I am using Visual Studio 2010 and have two tables in the Datasou…
3 replies
Hi, In SQL 2000, we could have a list of all indexes on a table at a glance. How can I provide thi…
9 replies
I'm looking to send out an email notification if a replication fails for any reason. Is there a wa…
1 replies
My little test db has exploded to 700 MB, log file 30MB How does one shrink it ??? Code or manually…
9 replies
Assumptions: 1) 'DIM_User_Approved' is my custom table that I hold all my members details ( rather …
3 replies
Can anyone tell me why this query is not working? The PercentofTotal column always returns all 0's…
4 replies
This shouldnt matter when you test it : WHERE LoweredRoleName NOT IN('expired','admin') DECLARE @l…
4 replies
I'd like to create a database using a stored procedure that accepts the database name. After some …
5 replies
i have a table with all the followups we do for students. For each participant, we have n number of…
2 replies
I have a table say my table with 200,000+ rows. It has couple of fields defined with datatype XML s…
1 replies
4 replies
Hi everyone; I need your help! I'm trying to create a report that is going to list out the custome…
9 replies
I have added a table to an existing ecommerce system and am having troubles understanding joins. So…
4 replies
Viewing 15 topics - 871 through 885 (of 2,735 total)
You must be logged in to create new topics.