Viewing 15 posts - 13,096 through 13,110 (of 14,953 total)
If you go into the tables tab in Access, it has an option for showing hidden/system tables. The data you need should be in those. I don't remember...
June 30, 2008 at 9:44 am
You could try copying the data over. I'd do it to a dev box first, so if it blows anything up, you haven't messed up a production server.
June 30, 2008 at 9:41 am
Microsoft has the whole story on their page, regarding which versions of SQL 2000 can be upgraded to which versions of 2005.
As far as moving a license from one server...
June 30, 2008 at 9:39 am
Personally, I prefer VB, but that's simply due to the fact that my first programming experiences were in VBA, and VB.NET was easier for me to pick up.
As far as...
June 30, 2008 at 9:36 am
The thing about resources being exceeded makes me wonder if you have some application not cleaning up its connections. Can you check for that?
June 30, 2008 at 9:28 am
You don't want SQL Server decrypting it. You want the front-end or data-connection layer decrypting it.
Think of it this way:
Someone steals a copy of the config file. They...
June 30, 2008 at 9:26 am
Do you have software running on that server (applications or services) other than Windows and SQL Server? Do you have calls to external DLLs, either via sp_OACreateObject, xp_CmdShell, or...
June 30, 2008 at 9:22 am
I generally operate in case-insensitive as far as the database is concerned, but I prefer CamelCase for naming. I find it easier to read.
I have places where I violate...
June 30, 2008 at 9:18 am
No problem. Welcome to a great SQL site.
June 30, 2008 at 8:58 am
You're very welcome. Glad I could help. It was fun digging into this one. 🙂
June 30, 2008 at 8:54 am
All I can suggest is get a hold of whoever that database is made by and see if they have any suggestions.
June 30, 2008 at 8:42 am
venki (6/26/2008)
But Common Table Expressions (CTE) are not working in SQL server 2000. We are using SQL server 2000 database.
Please help me how to achieve the...
June 30, 2008 at 8:38 am
Not strange at all if it's going beyond row-locks into page/extent/table locks. That's why I said trace the deadlocks (Books Online says how to do this and what options...
June 30, 2008 at 8:23 am
However you are calling the function, you put error-handling in there.
For example, if you have a function that select the first employee ID in a department, you might have a...
June 30, 2008 at 8:14 am
Try this, see if it does what you need:
;with Main as
(SELECT a.ClassId, s.race,
SUM(
case
when a.Status='P' then 1
else 0
end) AS Present,
SUM(
case
when a.Status='A' then 1
else 0
end)...
June 30, 2008 at 8:11 am
Viewing 15 posts - 13,096 through 13,110 (of 14,953 total)