what did you have to tweak? your answer might save someone else...

its possible it was marked as a system object; try sys.all_objects instead.

can you try assigning the name to a variable and renaming it?

DECLARE @tb sysname

select @tb = name from sys.tables where name like 'Table%' and name like '%Name'

exec sp_rename @tb,'Table_Name'

the sub folders would server no purpose then,except make the processing a little more difficult. processing a single folder vs lots of subfolders just adds to teh complexity of later...

i assume by you saying "But print statement dos not work correctly!!" you mean they don't print when you want them to, but when the batch completes, right?

you can use...

i have this saved in my snippets, I've only used it a handful of times.

rather than rebuilding the emails, it's just re-queueing the email as however it was originally built:

declare...

if the parameters are datetime data types, it should not make any difference, right?

the values are valid, you are not getting errors, you just happen to see the difference...

rather than an arbitrary count of 1000 or some other static value, would it make more sense to put files in folders based on the dates?

you could group by month,...

GREAT job providing the setup.

in this case, since you have to check for two values,, i think you want to join the table against itself.

you can join the same table...

I'm under the impression that Express with advanced tools installs the SQL and SSRS, but also installs a small version of Visual Studio, with the templates for creating SSIS packages...

I carry LinqPad around on a thumb drive if i happen to wander to a desk without my favorite tools.

you can install an unlimited number of SQL Server Management Studio...

I've never gotten a DSN-less Access linked server to work.

the link below will get you rolling, but if you have Office installed on your local machine, a side affect is...

I misread your question as moving off of the Os drive, insteadof what you asked;;;

so should tempdb.mdf be T:\tempdb.mdf vs T:\SQLData\tempdb.mdf ?

i'd say folders make things more organized, so...

i would use a view that does the calculation from your post above, and then you can poll the view instead of the base table. that is the easiest route,...

scotsditch (9/15/2015)

---

Hi I'm trying to create a temp table using the script below and it's taking forever. I was hoping someone might have some tips on hows I could...