Search results for query: *

Thanks for replying! :-) Actually, that's what I ended up doing and it worked! I also ended up using a table variable (since it has to be a function) and a CTE to make sure I don't count the same month twice. It's possible someone could take leave for one week in the middle of the month. That...

SQL Server 2005 sp3 This is driving me nuts. It's probably a simple solution but I'm just not seeing it. We have a table of employment records like this (simplified): ID fromDate throughDate type ---- ---------- ----------- ---- 1 2009-08-02 2010-09-12...

Glad to hear it

Is it an active/passive cluster or active/active?

I have SQL Server Management Studio 2005 (9.0.4035) and 2008 (10.0.2531) installed on my computer (Windows XP). Today when I opened the replication monitor in SSMS 2005 connecting to a SQL 2005 server, all of my publishers (SQL 2005) were either missing or had a red X on the name. I re-added the...

Thanks

What version of SQL Server are you using? If it's 2005 or 2008, there's a template regarding this sort of thing. It's called "Direct Reports Recursion Example". It basically uses a CTE (common table expression). http://technet.microsoft.com/en-us/library/ms186243(SQL.90).aspx Hope that helps!

Hello all! When I run T-SQL to drop and re-create a specific stored procedure on a development server, I get a stack dump every time and it disconnects my session from the server. Server Info: SQL Server 2005 SP3 (9.0.4035) Windows Server 2003 Standard SP2 2 GB RAM The procedure contains a...

Using Reporting Services 2005, does anyone know how to format a column cell in a matrix so that it reads from bottom to top? I have the writing mode set to tb-rl but it reads from top to bottom. Can this be rotated so that it reads from bottom to top instead? Any help is appreciated! Thanks! :-)

Aha! Thank you both for replying. George, that example shows it perfectly! It makes perfect sense now! Thank you so much! :-)

Thanks for replying. I know what you're saying. Here is some code to show what I'm asking. Which of the two statements below is better? select o1.name ,Address.streetNumber ,Address.streetName ,Address.zip ,Address.city ,Address.state from vwNam o1 left join dbo.Contact on...

Hello all, I'm a bit rusty with database development and am hoping someone could help me figure something out. Normally when I write select statements with joins, I don't include things such as "and codeDeleteFlag = 'N' " as part of the join clause. I usually put this in a where clause. Is it...

I have yet to find a way to change the connections other than opening each one and changing it. Sorry. :-(

What I did was follow the instructions in the link below. I used the data pump task to copy the packages from msdb.dbo.sysdtspackages to the same table in the other server. http://www.sqldts.com/204.aspx It worked great for me. Hope this helps!

I don't think there's a difference, but I could be wrong. :-)

I believe that just because the Start, Stop options are greyed out that doesn't necessarily mean the Agent wasn't installed correctly. I'm looking at one of my 2005 installations and the agent is running fine even though the Start, Stop options are greyed out. Have you checked the...

One option could be to encrypt the actual data files using something like Windows File Encryption System. Another option would be to secure the server or computer the files are on to prevent someone from getting to the files in the first place.

Have you tried sp_grantdbaccess?