.NET

Technical Article

RE: HELP!! Linked server with informix

  • Reply

Estoy seguro que si instalas un servidor SQL-Server en XP y repites los mismos pasos que has hecho, si te funcionará. El problema son algunos SP's que le hacen falta al NT, lamentablemente aún no he detectado cuales son exactamente, ya que aún no puedo vincular un servidor sql con informix en un Win NT, unicamente […]

You rated this post out of 5. Change rating

2005-04-07

Technical Article

RE: Database Create Date after restore.

  • Reply

Looks good to me.  The only part I'm not completely understanding is..."I just have to run a delete xp_cmdshell 'delete L:\MSSQL\BACKUPS\PRODEOM.BAK' a couple days after so that if I have a crash it is recoverable."I'm not sure how deleting the backup improves recoverability.  To me, if you leave it there (assuming sufficient space), your recovery […]

You rated this post out of 5. Change rating

2005-04-07

Technical Article

Auto-generate SQL Script for entire DB?

  • Topic

I know how to manually GENERATE SQL Script for all objects in a Database (using E/M, right mouse-clicking a DB, Generate SQL Script, then checkmarking all boxes, etc.)Is there a way to accomplish this automatically - to schedule a SQL Server Job to Automatically script all objects in a database?(developers want an automated, nitely mechanism to dynamically […]

You rated this post out of 5. Change rating

2005-04-01

Technical Article

RE: Starting MS SQL Server...

  • Reply

1. To Check the version:  On Registry check the following for SQL Server version   \\HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSSQLServer\CurrentVerion    From the version number, you can drive it's Service pack and hotfix level.2. Change the SQL Server service account to 'Local System account" from the Control Panel --> Services for SQL Server. Then put the current password in SQL […]

You rated this post out of 5. Change rating

2005-03-31

Technical Article

Creating a Daily Visual SourceSafe (VSS) Label with A SQL Agent Job

  • Article

I worked in a team recently that was failing to put Visual SourceSafe (VSS) labels on projects after they were checked in we decided to look to automation for a solution. What we cam up with is to continue to require that labels be put on versions of code when major builds where created. But we decided to augment that with automated daily labels.

2005-03-21

1,960 reads

Technical Article

RE: can you use ''''24hours'''' or /close'''' as a column name?

  • Reply

I'm wondering if you could use a different desgin in this case. Would it be possible to move that info in another table like OpenHoursType or something like that and use a foreign key for DRI? It would allow you to use a combobox instead of a series of checkboxes... especially usefull is someone comes […]

You rated this post out of 5. Change rating

2005-03-18

Technical Article

Optimizing Your SQL Code with SQL Server 2005

  • Article

A common complaint of database administrators (DBAs) is that performance bottlenecks are not among those problems that one can fix "by just throwing hardware at it." Thus, database servers must provide tools and techniques to help administrators address this issue. On that aspect, SQL Server 2005 does not disappoint.

2004-12-16

2,373 reads

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers