In SSMS, if you look at the Storage tab on the properties of a table, you can get the row count for that table. If you use Profiler to...

no need to move system databases. is there any specific requirement? you can script out the logins , permissions and Sql jobs and deploy it to your new partition.

Please...

I don't know any way of doing that, but it should be fairly simple to set up, something like this:

SELECT 'USE ' + name + CHAR(13) + CHAR(10) + '...

Join the table to itself on SSN = SSN and Contract_Number = Contract_Number + 1. You can then use DATEDIFF to get the differences between the times.

John

You shouldn't (and indeed I believe you can't) update system tables directly. Use the stored procedure instead - it's called something like sp_addjobschedule.

John

Network drive, certainly. Use a UNC path and...

Have you tried DENY DELETE ON TableName TO LoginGen on all tables?

John

What is the size of your model database? DBCC SHRINKFILE won't shrink your database any smaller than that.

John

raotor (1/18/2012)

No, there's nothing attached to your previous post. Click on Edit Post and then click on Edit Attachments to start uploading them.

John

Can't see those report files.

You are using SQL Server 2998, aren't you?

John

You need to use it, for example, if you have a code block longer than one line to be executed (or not executed) in an IF construction. Otherwise, it's...

I'm stumped, then. The only thing I can think of for you to try is create the table without the foreign key, then use ALTER TABLE to add...

Can't see anything wrong with that. Does the statementHistory table definitely exist when you are trying to create the categories table?

John

As Paul and Cadavre have already asked, post your table DDL and some sample data and it'll be a lot easier for us to help you.

John

Or maybe...

WITH CTE AS (

Select wrp_sys_User.IntUserId, wrp_sys_User.chrForename + ' ' + wrp_sys_User.chrSurname as chrFullName, U.intUserID, U.chrUnAllocatedUser

from wrp_team inner join wrp_TeamUser on wrp_Team.intTeamID = wrp_teamUser.intTeamID

inner join wrp_sys_User on wrp_teamUser.intUserID = wrp_sys_User.intUserID

inner...