I'm not sure if I understood what you are looking for, but if you want to know which fk column of a table references to which other object this should...

I'm also not sure about your problem, but maybe your solution is just this:

DECLARE @person TABLE (id INT, name VARCHAR(100), dob datetime)

INSERT INTO @person

...

If you want, I can attach the C# source code and/or the assembly (if you trust me :-D).

I just don't know if the forum allows to attach a zipped executable...

Try this:

DECLARE @t TABLE (student INT, dt DATETIME, missed BIT)

INSERT INTO @t

-- today

SELECT 1, DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE())...

can anybody tell me how 1 can get PRINT statments from SP execution at client side?

I found it really useful in some cases when we need to log the actual...

Hi Michael

Not any reason. I also noticed the script and I have to say: "Respect for the creativity...

We used the truncate_only functionality for development and test databases. For some load tests we take production databases to our test system. Our test environment is not as large as...

Oops... sorry!

@Flo

Read slow!

Thanks GSquared!

Hi

I'm not sure if I understood you correctly, but this?

SELECT *

FROM AnyTableWhoseNameYouDidNotSay

WHERE missed = 1

If not please provide your table definition and some sample...

Ask the administrator to reset. If you are the administrator login to the windows server and connect to SQL Server with windows authentication. So you can reset the password.

Greets

Flo

Hi

I don't know anything about the SQL Server Express gui tools, but have a look to registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL9.MSSQLSERVER\MSSQLServer

There should be a "BackupDirectory" configured. Change it and restart the service....

I would never say that perl is easier to read :-P. Just my admins do.

As a said, I am using C# scripts:

using System;

using System.IO;

void Main()

{

string[] files =...

:w00t:

So that's exactly what I'm speaking about...

Fortunately I don't have to. I'm a developer, not an...

Hi

Try this:

DECLARE @T TABLE (id int, txt NTEXT)

INSERT INTO @t

SELECT 1, '<root>

<response>

<whatIwant test="bla">value</whatIwant>

...

bitbucket (3/27/2009)

---

Sorry do not know of a work book, but use these forums and try to answer any question on T-SQL BEFORE looking at any answer which has been posted...