Search results for query: *

Thanks for replying. The stored procedure already checks for bad dates and returns an error message. I'm just not sure how to check for that error message in the report itself. Thanks

I'm designing a report using Reporting Services 2000. The data source is based on a stored procedure. There are two data parameters - a start date and end date. If a normal start and end date is provided (such as 4/1/09 and 4/20/09) the proc returns a description and a record count for that...

Yes, it makes sense to me. I'll give it a shot. Thanks! :-)

Is it possible that the code below is causing deadlocks because of how it's written? Meaning, the table being updated is also referenced in a subquery within the update statement. We know deadlocks are occurring on the tables and this stored procedure was captured in an SQL profiler trace. Would...

What you said makes sense to me. In this particular case, this function was used in only one stored procedure. So it probably didn't need to be a function in the first place. Thanks again for your help! :-)

That's basically what I told the developer who is stuck with fixing it. She took a stab at it yesterday and managed to rewrite the select statement without the function. It appeared to work great! I know we have more of these to fix but it's a start. Thank you! :-)

System: SQL Server 2005 SP2 We recently discovered a stored procedure containing a large complicated select statement. When the stored procedure is executed by one person, the select statement shows up in an SQL Profiler trace about 500 times. The EventClass I used is "SP:Completed". The...

From what I've read, DTS won't be supported in future upgrades of SQL Server. So it's a good idea to eventually re-write the DTS packages using SSIS. In the meantime, I personally haven't had any problems running our 40+ SQL 2000 DTS packages with the SQL 2005 database engine. Some of them are...

I'm not sure what happens if you do an in-place upgrade. However, I do know that if you install SQL Server 2005 on a separate server and migrate everything to that server, you can still use DTS packages. Before you migrate the DTS packages, you have to install the "SQL Server 2000 DTS Designer...

For anyone else curious, the answer is yes it will work just fine. Apparently I got confused with scale-out deployments and remote databases. For some reason I thought they were the same thing but they aren't. I swear my brain is around here somewhere! [morning]

Is it possible to install SQL Server 2005 Reporting Services Standard Edition on one server and install the database engine (SQL Server 2005) Standard Edition on a separate server? I'm concerned about it being Standard edition. Will this work? Thanks!

Thanks for replying. The task has been given to our Oracle DBA since she knows both Oracle and SQL Server. She feels it will work just fine. Guess we'll see what happens. Thanks! :-)

Is it possible to create an indexed view in SQL Server 2005 on a table that resides in an Oracle database? If so, how would you go about doing so? Using a linked server? Thanks!

I didn't think the extension mattered. Also, there are no separate files or file groups other than the default ones. Thanks!

Hi everyone, When we back up SQL Server 2000 databases, we use the following t-sql statement. Does anyone see anything majorly wrong with it? BACKUP DATABASE [MyDB] TO DISK = N's:\ MSSQL\Backup\MyDB.dat' WITH INIT , NOUNLOAD , NAME = N' MyDB backup', SKIP , STATS = 10, DESCRIPTION =...

Nevermind. Silly question.

Good points, MrDenny. I wasn't thinking straight. Windows Authentication is more secure. Sorry about that. :-)

If the only admins you're worried about are those who have access to the actual server, then how about removing the built-in administrator account on SQL Server and requiring SQL authentication? You'd have to make sure it wouldn't break anything but it could help. Just a thought.

Hi everybody, I'm a bit confused about how to proceed with SQL Server 2005 hotfixes. Most of our servers that have SQL Server 2005 have build 3159. I know there's a new security hotfix out (bulletin MS08-040) which we need to apply to our SQL servers. For those that currently have build 3152...

Hello! We have SQL Server 2005 Enterprise Edition SP2. Does anyone know if database mirroring will work okay with RSA SecurId? I tried Google'ing it and searching on the RSA SecurId website but couldn't really find anything. I'd appreciate any comments on it. Thanks!