Check your authentication methods. Open up Enterprise Manager, expand your SQL Server group, and Right-Click on the server. Select Properties from the drop-down menu, and select the Security tag. Now, since it appears that you are using name/password security, make sure that you are using both SQL Server and Windows authentication. If you are not […]
2003-06-23
1 reads
Don't know about the maths, but agree fully with the "try to enforce strict requirements so developers cannot alter anything in production. ". Reason, that last minute fix/enhancement but give developers freedom on there development box, preferably on there own desktop. Lastly configuration management can be a problem if changes are applied to undocumented.
2003-06-05
2 reads
Did you try any of these solutions? If so which one solved your problem, it seems to me some of the solutions were a bit too complex for what was required.
2003-06-05
2 reads
I may be missing something here but what about: CREATE PROCEDURE myprocedure @strOut1 varchar(5) = NULL OUT , @strOut2 varchar(5) = NULL OUT , @strOut3 varchar(5) = NULL OUT AS BEGIN DECLARE @cmd nvarchar(1000) SET @cmd = 'SELECT @sOut = Col1 FROM database.dbo.TABLE1' EXEC master.dbo.sp_executesql @stmt = @cmd , @params = N'@sOut varchar(5) OUT' , […]
2003-06-05
1 reads
Unless I have missed something in your requirements, will the following give you ther required results: CREATE PROCEDURE myprocedure @out_var1 varchar(5) OUTPUT, @out_var2 varchar(5) OUTPUT, @out_var3 varchar(5) OUTPUT, AS BEGIN set @out_var1 = (select count(id) as count2 from foobar where theId = '2') set @out_var2 = (select count(id) as count2 from foobar where theId = […]
2003-06-04
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers